A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Countifs anchoring formula when sorting by rmclafferty1
My Countifs seems to work as long as I do not sort. For example, I want to sort by date rather than name: • Bob Smith that was on line 12 is now is on...
May 17th, 2010 02:55 PM
by Luke M[_4_] Go to last post
1 235
Matching two groups of data within one sheet by HeatherJ
I have two groups of data A2:D1564 and F2:J1417. Each has a column (D & F) with 10 digit assignment numbers, most of which match from the 1st group to the...
May 17th, 2010 02:49 PM
by HeatherJ Go to last post
0 190
Conditional Formatting in 2007 by Live Long & Prosper
Playing with Excel I'm trying to conditionally format cells that divided evenly in a range, heres a simple example :) In cell A1 I put '=50000000/row()' I...
May 17th, 2010 02:46 PM
by Live Long & Prosper Go to last post
4 284
In Excel, when i key in 02352 and press enter, the zero goes off by Query
In Excel, when i key in any group of numbers with a zero preceding it, and then press enter, the zero disappears. How do i for instance key in 02352. with...
May 17th, 2010 02:19 PM
by trip_to_tokyo[_3_] Go to last post
1 180
Splitting cell contents into 2 cells by Florence Tay
If a cell contains a set of numbers separated by a hyphen (eg, 1234-5678, can the contents be splitted up into 2 cells without the hyphen (ie, 1234 in 1 cell...
May 17th, 2010 01:55 PM
by Luke M[_4_] Go to last post
1 190
Form command not working on worksheet with merged cells by JohnH
Hi, I have a workbook which I set up to use Form entry using the table headers. The form worked fine until I merged a couple of cells just to the right of...
May 17th, 2010 01:28 PM
by JohnH Go to last post
0 182
Drop down boxes by themase
Hello i have a column of 'names' which i have used a dropdown list to produce i.e. date name(drop downlist) 01/01/2009 ...
May 17th, 2010 01:05 PM
by sidm via OfficeKB.com Go to last post
1 178
Divide by 0 Help by joey_boy
=(SUM(E98:F98)+D98/2)/(I98-G98) Any suggestions on how I can rewrite this to return 0 if I get a Dicide by 0 Error in any of the calculations. I am a bit of...
May 17th, 2010 01:00 PM
by sidm via OfficeKB.com Go to last post
4 188
Counting Checkmarks by John Moore
Is there a way to count checkmarks ,, I have a sheet with lots of checkmarks in columns, I want to be able to have a count of the number of checkmarks in any...
May 17th, 2010 12:59 PM
by Dave Peterson[_2_] Go to last post
1 192
Div 0 help by joey_boy
=(SUM(E98:F98)+D98/2)/(I98-G98) This formula gives me a Div 0 error. How can I re-write it so that it stores a value of 0 , if it encounters a Divide by 0...
May 17th, 2010 12:56 PM
by Dave Peterson[_2_] Go to last post
1 125
Invoices by suewalton21
I have a worksheet for 37 addresses, showing various charges I need to produce a single invoice for each address Any help please
May 17th, 2010 12:55 PM
by Eduardo Go to last post
4 222
Three Variable Correlation by Eileen
Hi. I was wondering if it was possible to work out the correlation between three variables in excel, not just two. My data looks like this (this is just an...
May 17th, 2010 12:38 PM
by Eileen Go to last post
0 115
Three Variable Correlation by Eileen
Hi. I was wondering if it was possible to work out the correlation between three sets of variables in excel, and not just two. The data looks like this...
May 17th, 2010 12:21 PM
by Eileen Go to last post
0 110
Drop down box! by themase
Hello i have a drop down box which contains names of workers this has been used to populate who works where in a spread sheet! what i need to do is edit the...
May 17th, 2010 10:15 AM
by Roger Govier[_8_] Go to last post
1 172
where can i find credit notes by annatjie
i can do a invoice but need to do a creditor note. where can i find it?
May 17th, 2010 09:31 AM
by annatjie Go to last post
0 126
Convert text to number automatically by Matt
I am trying to compare drawing revisions from 2 different sources but am having difficulty due to the sources having either text or number formats. Sheet 3...
May 17th, 2010 09:11 AM
by Matt Go to last post
2 142
Filling adjacent formulas with data import by Dave
Hi all, XL2003 2nd posting - first on ended up in the ether... I've tried importing a .txt file (from the Data menu) with the "Fill down formulas in columns...
May 17th, 2010 08:44 AM
by ozgrid.com Go to last post
1 215
May 17th, 2010 08:30 AM
by 資訊函數 Go to last post
0 115
Import data, fill adjacent formulas by Dave
Hi all, XL2003 Using the Import data from the data menu, I have just discovered, and am trying to use, the "Fill down formulas in columns adjacent to data"...
May 17th, 2010 07:39 AM
by ozgrid.com Go to last post
1 253
Sumproduct of multiple sheets by Radhakant Panigrahi
Hi, I am using the below sumproduct formula, =Sumproduct((Sheet1!A1:A50000="Mark")*(Sheet1!A1:A50000="Automatic")) I have 25 sheets and i have put the...
May 17th, 2010 06:34 AM
by Radhakant Panigrahi Go to last post
0 180
Post New Thread


Display Options
Showing threads 841 to 860 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.