Is there a way I can do effectively a "rankif" formula via some array
trickery?

I've set up Excel to import web data into a table,

let's say COl A is the names, Col B is some kind of category, Cols C-F are
data, and in Col G I do some calculation based on cols C-F.

What I want to do is be able to automatically have a ranking but within a
category, and have that in Col H, so the ranks 1,2,3,4 etc appear for each
individual category, there will be different items in each category and the
list might even be mixed up, ie not in category order

does that make sense?

thx in advance