Tags Tags

Formula for multiple rows of same value...

April 21st, 2012 - 06:21 pm ET by mslabbe | Report spam
Help Create a new topic
I have two tabs in a excel sheet. One tab has rows of dates (multipl
rows - 10 of the same date to be exact) in which I'd like to look up
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 lik
using the offset formula or pivot table.

Ex
A--B
1-4/5123
2-4/5456
3-4/5789
email Follow the discussionReplies 2 repliesReplies Make a reply

Similar topics

Replies

#1 Vacuum Sealed
April 21st, 2012 - 10:38 pm ET | Report spam
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/5123
2-4/5456
3-4/5789




Hi there

This is a good starting point for you.

http://www.cpearson.com/Excel/FindAll.aspx

Chips provide numerous examples.

HTH
Mick
Replies Reply to this message
#2 Don Guillett
April 22nd, 2012 - 01:22 pm ET | Report spam
On Saturday, April 21, 2012 5:21:48 PM UTC-5, mslabbe @ hotmail. com 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/5123
2-4/5456
3-4/5789



Probably a macro to use
data>filter>autofilter>filter your date>copy to other sheet
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search