Capture lines with entries?

J

Jacob Skaria

All 3 solutions should work fine in 2003. I am using 2003 and 2007 and I have
tested these formulas in 2003. I tried out copying your data straight away to
Sheet1 colA/B

The last solution do not use the functions you mentioned as not working like
INDIRECT,SMALL etc; I am unable to test this as I dont have a Mac or have
never worked with 2008.

If this post helps click Yes
 
W

Wind54Surfer

Thanks a lot for your great help!

Emilio

Jacob Skaria said:
All 3 solutions should work fine in 2003. I am using 2003 and 2007 and I have
tested these formulas in 2003. I tried out copying your data straight away to
Sheet1 colA/B

The last solution do not use the functions you mentioned as not working like
INDIRECT,SMALL etc; I am unable to test this as I dont have a Mac or have
never worked with 2008.

If this post helps click Yes
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum work hours to hours & nearest 10th of an hour 14
Rank If - SumProduct - HELP PLEASE 1
use more than 7 if condition in a cell 8
sumproduct with unhidden data 1
New hardware order for Skybuck's Dream PC (2006) ;) 3
Calculate discount amt with conditions 3
GET QTY in column J 11
What should formula look like to define date range on SUMIF 2

Top