| View previous topic :: View next topic |
| Author |
Message |
netstv
Newbie
Joined: 22 Apr 2012
Posts: 1
|
 Posted: Sun Apr 22, 2012 8:11 am Post subject: Formula between worksheets help |
 |
|
So I have what I think is a simple problem, I'm just not good at Formulas yet.
I have three worksheets for our baseball season tickets.
one is the "summary page" This includes columns titled:
date owner amount barCodeSeatOne barCodeSeatTwo
And of course this entire sheet is all of our 82 games.
We have two owners (myself and my uncle)
I want to create two other worksheets.
One for me
One for my uncle.
So these two worksheets will "parse" the first worksheet to walk down the "owner" column and then if the owner matches the sheet name, display that column.
I would appreciate any help you could give me.
I was thinking to display the entire worksheet and then hiding rows that don't match. Is that how I would do something like that?
Thanks in advance.
steve |
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 330
Location: victoria
|
| Posted: Sun Apr 22, 2012 9:04 pm Post subject: |
|
|
Bit of guess work here so you may need to adjust this
I have put your data in A2:E83 (row1 being your headers)
I created a helper column in G
Helper column formula in G2 dragged down to row 83
| Code: | | =IF(B2="me";ROW();"") |
Formula for 'me' sheet in A2 (dragged across to column E and down as far as neccessary
| Code: | | =INDEX($Sheet1.$A$1:$E$83;SMALL($Sheet1.$G$2:$G$83;ROW($A1));COLUMNS($A$1:A1)) |
New helper column and sheet for uncle
Helper columns can then be hidden after its set up if wanted
Hope this helps
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
