First  |  Prev |  Next  |  Last
Pages: 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
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. 27 May 2010 17:04
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
First  |  Prev |  Next  |  Last
Pages: 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46