I am using formula =If(A1>B1,"X",If(A1=B1,"XX",If(A1<B1,"XXX","")
I am using this formula my data is large and this formula hangs my excel so i need alternate of this that can't effect the speed of excel
I am using formula =If(A1>B1,"X",If(A1=B1,"XX",If(A1<B1,"XXX","")
I am using this formula my data is large and this formula hangs my excel so i need alternate of this that can't effect the speed of excel
Re: Reg change of formula
This is a very simple formula, so it should not cause serious speed overheads. How big is the dataset? What else is going on in the workbook?
Re: Reg change of formula
From A1:XFD1102 total data & there are numbers and this formula starting from ES coloumn to XFD coloumn
Re: Reg change of formula
If formula slow don the excel that i know 101% sure give me the alternate of this formula alig
Re: Reg change of formula
There is no simpler way of doing it, so I can't give you a formula that will perform better. Even given the size of your data, there should be no problem. Maybe your PC just isn't powerful enough?
Re: Reg change of formula
You could try attaching the file here for someone to have a look at - that way we can really see what's going on.
Re: Reg change of formula
Amd 1.4ghz processor 2gb ram is enough or how much is required any idea alig
Re: Reg change of formula
More than enough for this formula. Something else must be going on. Please provide the workbook.
Re: Reg change of formula
K Let me check my data and thnx
Don’t have an account yet? Register yourself now and be a part of our community!