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

Uneven column lookup 4
Rank If - SumProduct - HELP PLEASE 1
15 minute data to daily data 1
Ranking Multiple Columns 3
use more than 7 if condition in a cell 8
sumproduct with unhidden data 1
What should formula look like to define date range on SUMIF 2
GET QTY in column J 14

Top