HI,
Need some assistance, please see my uploaded workbook. I have sheet 1 raw data and sheet 2 dashboard, the formulas (vlookup) are structuring the data in the dashboard, I need a formula that can avoid the non-active accounts or the closed ones from the raw data sheet, more and more data will be placed into the raw data but overtime some of those rows will be closed.
Please see workbook,
Thanks,
Noah
Try array entering this formula in B3 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.and array entering this in C4. Fill down and across.Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Dave
Amazing! it worked, thank you FLAME! , I didn't come across this formula before so this one is brand new to me. I have seen many interesting excel tricks but this one I haven't come across until now, very nice! I just had a feeling it could be done.
Thank you!
Noah
You are welcome. Thank you for the feedback, rep and marking this thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks