Hello
I have used a dynamic array in office 365, however, it does not work on other versions of office.
I need a formula replacement.
Expected results are in yellow and green as the dynamic array will fail for 365 users, on the sheet2 tab I need this to report from the sheet1 tab, but only report the lines of data that relevant i.e., the number of pallets in col y.
cheers
Try, in A3 copied across and down
In H3 copied across and downFormula:
Please Login or Register to view this content.
Does that work for you?Formula:Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
class, thanks buddy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks