Index / Match query

[EvansB2]

Hi there,

I have copied the following formula from a workbook produced by someone else:

=INDEX('£m2 Site RUN RATE '!$C$79:$C$99,CEILING((ROW()-1)/(MATCH("zzz",'£m2 Site RUN RATE '!$79:$79)-1),1)+1)

The objective of it is to re-produce data in one worksheet into a new 'columnar' based worksheet. However, it is only listing 17 entries (rows) and then moves to the next site name.

Can anyone tell me what specific part of the formula drives this?

Regards

Ben

 

[Gerald Higgins]

Deleted

 

[EvansB2]

"Deleted"?

 

[bensmith1987]

I have a feeling its to do with the Row() part which refers to the current row then divides this by a match formula.
However it's difficult to tell without the source sheet which often helps to understand the root cause.

Any chance you had remove or anonymize confidential data and post a copy of the file?

Thanks
Ben

 

[EvansB2]

Hi Ben,

From previous experience, I don't believe you can attach any files in this forum? What would be the most effective way of presenting the data? I'm on excel 2016.

Regards

Ben

 

[gaz_chops]

I think Gerald Higgins simply meant he had deleted his post.

Check my sig for options to post sample data here.

 

[EvansB2]

Hi,

I have Mr Excel HTML Maker as an Add-in now. However, When I select the cells, click "All Formulas" and paste to this forum, get the following "? ?" (set in black diamonds) and doesn't change when I click Preview.

Have you come across this before?

Regards

Ben

 

[Gerald Higgins]

Yes that's what I meant.
I wrote some comments, including a suggestion on what might help, but then realised I was mistaken.
So I deleted the text in my post.

 

[EvansB2]

OK. Worries. Did you see my query above regarding HTML Maker? You may have seen this issue in your time, if so I would appreciate any advice you may have?

Ben