Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello,I am Pete, and I'll be happy to assist with your question today.
Can you describe the purpose of the formula for me?
You can ignore any automated offers that may pop up - they are sent automatically by the site.
That's ok, I understand! Just ignore any automated offers of remote assistance.
Can you tell me which cell(s) are not functioning as expected?
Yes, looking at it now...
Ok, almost there..
Your formula would work if it was pasted across 3 columns and down each row, with no missing rows in between.
However as the formula jumps from row 1 to row 5, it loses count of the array.
The following formula is closer to what you require but still needs some tweaking:
I still can't get it fully tweaked to work correctly!
I will opt out and see if another expert can assist you further.