Slow VBA Code

[jonjones069]

Hi Forum, I am creating a macro to turn raw data into a condensed form, the rest of macro is super quick but this particular part is not, Can anyone please recommend a way to make this formula quicker? =IF((RC[-1]<>""Clubbing""),(IF(OR(RC[-1]=RC[-8],RC[-1]<RC[-8]),""Sports"",""Other"")),""Hardwell"") *Note* for work reasons I could not have the actual words used, thanks for your help

 

[jonjones069]

=IF((RC[-1]<>""Clubbing""),(IF(OR(RC[-1]=RC[-8],RC[-1]<RC[-8]),""Sleeping"",""Sports"")),""Yolo"") The code didn't post for some reason, here it is in full

 

[jonjones069]

post isn't loading properly, you can close this thread, i'll figure it out myself