Thread
:
Formula for multiple rows of same value...
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Vacuum Sealed
external usenet poster
Posts: 259
Formula for multiple rows of same value...
On 22/04/2012 8:21 AM,
wrote:
I have two tabs in a excel sheet. One tab has rows of dates (multiple
rows - 10 of the same date to be exact) in which I'd like to look up a
specific date and list the data that is in the next column to that date.
When it finds another of the same date, use the next one...almost like
using the offset formula or pivot table.
Ex
------A-----B
1----4/5---123
2----4/5---456
3----4/5---789
Hi there
This is a good starting point for you.
http://www.cpearson.com/Excel/FindAll.aspx
Chips provide numerous examples.
HTH
Mick
Reply With Quote
Vacuum Sealed
View Public Profile
Find all posts by Vacuum Sealed