True or false if 3 x cols equals one other col .

[I need excel help]

Hello all ,

Im wanting to get a simple fast working macro that can result a sheet with 550,000 rows .

All Im needing is to result True or False if cols BO , BU and CA equals col AE .

Results from col BO go into col CH
Results from col BU go into col CI
Results from col CA go into col CJ

There will be blank cells in cols BO , BU and AE . So result will be False
There are no blank cells in col AE .

Col AE contains text and numbers .

Thanks .

[jolivanes]

Don't know how long it'll take but try it on a copy of your original after changing references where required.

Please Login or Register  to view this content.

[I need excel help]

Hi , I tried that on a small sheet of 5866 rows and it worked instantly . Perfect so far , very happy .

To test on a 550,000 sheet I have to do some pre work (run other macros to give me the results in cols you used) so give me a couple of days as daily job is intense this week , 100% I will reply . This is an absolute must have macro .

Very happy , thanks , will get back to you and I think really it should work over time span .

[I need excel help]

I have a sheet ready with 54050 rows , turned my head for a couple of seconds and there were the results .

This is solved , many thanks jolivanes , this is so time saving from functions .

Will test over the big sheet when time permits , perfect result , thanks .

[jolivanes]

Glad to hear you've got it under control and working as needed.
Good Luck.