Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for multiple rows of same value...
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 . 11---4/6---321 12---4/6---654 13---4/6---987 . On the other tab is where I'd like to select the specific date and in the first row, grab the data from column B...the next row on that tab would grab the next row from the other tab, like this... ------A-----B 1----123 2----456 3----789 Does that make sense? |
#2
|
|||
|
|||
Quote:
I did an example to you. It´s attached. Take a look and tell me if it worked for you. There are only simple formulas on it. Have a nice day.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil Last edited by Mazzaropi : April 22nd 12 at 12:14 AM |
#3
|
|||
|
|||
Quote:
I see that it works, but I didn't want to have to edit the original page. I did have it where I numbered 1 to ~3700 (each day of the year X 10), but didn't want to do that either. Thanks for the example, but not exactly what I can use. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for multiple rows of same value...
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/5---123 2----4/5---456 3----4/5---789 Probably a macro to use datafilterautofilterfilter your datecopy to other sheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula For Multiple Rows | Excel Discussion (Misc queries) | |||
How to make Same formula over multiple rows but still holds row # | Excel Worksheet Functions | |||
How do I apply a formula to multiple rows at the same time? | Excel Worksheet Functions | |||
Apply a simple formula to multiple rows? | New Users to Excel | |||
Deleting multiple rows through a formula | Excel Discussion (Misc queries) |