It works great on Invoice 1, but when I switch to Invoice 2, it doesn't work. I know why. This part of the code (Task!$D$6:$D$11) needs to vary when I change from Invoice 1 to 2 or 3. I could do a switch formula, but I'm hoping there is a more elegant solution. Maybe nesting another match formula? Here's where I need your help!
|excel pivot question||4||40|
|First Blank Cell in a range||7||35|
|From msAccess SaveAs an excel file SILENTLY without opening excel||4||29|
|Issues with DAX Calculated Columns||6||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!