Hi Guys
I am trying to use index formula with multiple arrays
ex index((G4:H4,K4:L4),1,0), multiple arrays because i want to exclude some cells from the array
I have attached the sheet and have given the example, whats the right synatx of the formula to get desired result
I cant change the format of the sheet to suit the formula as its a client sheet
Thanks in advance!!
dont use index, use averageifS()...
=AVERAGEIFS($B$4:$Z$4,$B$3:$Z$3,"<="&$C$7,$B$3:$Z$3,">="&EDATE(C7,-2))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thnks Bro!!
It worked Awesome....
Happy to help, thanks for the feedback
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks