Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hello all,
I need help with a formula for Excel 2010.
I have a spreadsheet that is sent to me daily that grows in row length daily by 5-10 rows (varies). I need a formula on a seperate tab "Pivot1" to look to "End User" and go in Column A:A and look for a date that I list on "Pivot1" if you see it return the value in "End User Column I"
The problem I am having is that I don't know how to tell the formula =Once you find the date in Column A:A give me the results from column I until you don't see the date anymore.
So in theory for todays date my report should have given me 20 cells of data from column I on my "Pivot1" tab
I am so lost here! Please help, Thanks!
Again this is for Excel 2010
I need help with a formula for Excel 2010.
I have a spreadsheet that is sent to me daily that grows in row length daily by 5-10 rows (varies). I need a formula on a seperate tab "Pivot1" to look to "End User" and go in Column A:A and look for a date that I list on "Pivot1" if you see it return the value in "End User Column I"
The problem I am having is that I don't know how to tell the formula =Once you find the date in Column A:A give me the results from column I until you don't see the date anymore.
So in theory for todays date my report should have given me 20 cells of data from column I on my "Pivot1" tab
I am so lost here! Please help, Thanks!
Again this is for Excel 2010