General
in [Excel]
|
how to arrange list by first or last name I am trying to make a list with first, middle, last name , street address, and phone numbers. I like to know how you can review the list by any combination of first name, last name, city, state, and or phone number? ... 27 May 2010 18:11
Formula for multiple criteria on 2 worksheets Check your other posts in the below links for answers. http://www.microsoft.com/office/community/en-us/default.mspx?&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=5b0c0acc-24dc-49bf-9ec7-3d55103b4b5d http://www.microsoft.com/office/community/en-us/default.mspx?&lang=en&cr=US&g... 27 May 2010 17:04
Excel I want to lookup a date from a workbook to add to a specfic cell in another workbook, can this be done? I've tried a vlookup but this would mean that I will have to consolidate the sheets in one workbook to do this and this take too long and copy the consolidated data on to the workbook I want to do the looku... 27 May 2010 17:04
Partial editing of cell contents. Hi, I wouldn't let them anywhere near it because if you do it will end in tears!! Lets say you 6 segment numbers are in column A. Protect that column so it can't be altered. I think your number looks like this 123-456-789-986-654-321 Put this formula in (say) column C and drag down as required and once eg... 27 May 2010 17:04
how do i remove extra pages from my speadsheet? I have multiple workbook sheets with extra sheets attached. When I print if I don't select which pages to print it will print like 50 extra pages. ... 27 May 2010 20:23
compare and merge documents in 2007 How do you compare 2 excel documents with track changes and merge them together after accepting the changes in Excel 2007? ... 27 May 2010 15:58
rental equipment invoice I am trying to create a equipment rental invoice using one spreedsheet as the data base, I am stump on hoe to make the cell that will contain the charge of the rental If I use dates and in an cell I create a formula that figures out the number os days the equipment is out in the total charge sell I want the amo... 27 May 2010 19:18
Please help., Basically you will have a table of data. In VLookup there are 3 things, lookup value, table array and column. Note that the lookup value has to be on the first column on the left of the table, no other position. 1 a f 2 b g 3 c h 4 d i 5 e j Assuming that you have the 3 columns of data and the l... 27 May 2010 15:58
Correct a Cell How do you clear a cell from doing this 1E+305? It should read 1E305. ... 27 May 2010 18:11
Counting occurance of empty cells Perfect thanks, worked a dream "Tom Hutchins" wrote: Try =SUMPRODUCT(--(LEN(J157:J2643)>0),--(LEN(K157:K2643)=0)) I used column K per your instructions, although your example formula had column H. Hope this helps, Hutch "DaveC" wrote: Hi folks, I am trying... 27 May 2010 15:58 |