I'm trying to take data from tab 1
Col A Col B through G
Text Numeric Data
to
tab 2
Col A Col B through G
Display text only if there is any Data in B through G Numeric Data
There are numerous blank data rows
Thanks
I'm trying to take data from tab 1
Col A Col B through G
Text Numeric Data
to
tab 2
Col A Col B through G
Display text only if there is any Data in B through G Numeric Data
There are numerous blank data rows
Thanks
Post an example workbook - we can't see what you've got or what you want to do with it.
Pete
Here is an example file.
Data File is copied to Recap Tab without blank cells.
Thanks
Put this formula in L2 of the Data Sheet:
=IF(COUNTA(B2:I2)=0,"-",MAX(L$1:L1)+1)
and copy it down beyond your data - the hyphens will indicate how far you have copied it.
Then you can put this formula in A2 of the Recap sheet:
=IFERROR(INDEX('Data Sheet'!A:A,MATCH(ROWS($2:2),'Data Sheet'!$L:$L,0)),"")
This can be copied across to column J on that row, and the cells formatted as on the Data Sheet (use the Format Painter from there). Then that row can be copied down as far as you need it.
The attached file shows this in operation.
Hope this helps.
Pete
Or without the helper column this non-array formula in Sheet "Recap" A2, Drag Across to Column J, then Down
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks so much for this formula! It works great.
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks