Hi all,
Thank you in advance.
I wanted to filter Column G>0 (FROM tab RAW) and return the results of the column (G) and other other columns mentioned below.
Hi all,
Thank you in advance.
I wanted to filter Column G>0 (FROM tab RAW) and return the results of the column (G) and other other columns mentioned below.
The way I would do this is to use a formula in a helper column in the Raw data sheet which identifies the matching records (usually with a sequential number). Then in the other sheet you just need a simple INDEX/MATCH formula with the ROWS function.
Some people don't like helper columns, so would this approach be acceptable for you? (P.S. I'm about to go out, so I'll return to this later on).
Hope this helps.
Pete
Column A is a unique id which i did not show in the original sheet.
This might help in not needing a helper.
If it is still needed i do not mind.
worksheet name : Sheet2
Pls Click the left mouse button to select the ranges area A8:H8 ; pls Place the following formula in Formula Bar , then Array formula
Then copy this ranges A8:H8 , drag down
HTML Code:
I don't think that the formula above is an array formula... as this variant just needs ENTER:
=IFERROR(INDEX(RAW!$A:$U,AGGREGATE(15,6,ROW(RAW!$G$2:$G$50)/(RAW!$G$2:$G$50>0),ROWS(A$8:A8)),MATCH(A$6,RAW!$A$1:$U$1,0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
@Glenn Kennedy You are right, NON ARRAY FORMULA
worksheet name : Sheet2
Cell A8 formula , Drag down and across
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks