Results 1 to 2 of 2
2003-01-13, 04:11 #1
- Join Date
- Jan 2001
- Thanked 1 Time in 1 Post
Search thru file and calc formulas (Excel xp)
I have the spreadsheet attached. I need to search thru a file that has 50 of the tables attached (the attached only has 2). The cells that are red are the ones i need to find for all 50 tables. So in the first table, i need to look thru B8 to B17 and find the first cell that is <20. Then I need to put the value of that cell in H5 and the dollar amt it corresponds to in H4. I need to do cars 1 thru car 6 and then move on to the next table. Each "table" is separated by #page so i can search for page.
Could i get some help with the code...
search for "#page"
car1 code to find first value <20, get corresponding dollar amount in COL A
car1 code to find first value >70, get corresponding dollar amount in COL A
go to car2
Thank you for the help.
2003-01-13, 11:18 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Search thru file and calc formulas (Excel xp)
Instead of a macro, the following formulas, give what you want.
In H4 (with "<") you could enter something like:
For the ">" [This will actually find ">="] in I4/I5
You could put the 20 and 70 in a cell and reference them if desired, and these could be copied at the top of each of the tables.