Hi Alex You can refer here for a VBA solution : I would prefer this over any ARRAY formula. Hope this helps Sunny
Hi Lea I believe you wanted the 2nd TEL to appear in TEL 2 if the NAME and CITY appears a second time (duplicate). This is my suggestion. It wil...
Hi Lea No idea which phone number (1st, 2nd etc) you wanted to transfer. Maybe something like this? In cell D2 enter =IF(COUNTIFS($A$2:A2,...
Hi Eric Instead of a macro, would you consider using a helper column instead to identify the rows containing the text "freight"? You could then ...
Hi Melaine What you want will require VBA. You can refer this link for some examples on how it is done : Hope this helps. Sunny
Hi Salim You can try =SUMIFS(A:A,A:A,">=0.1",A:A,"<=0.49") =SUMIFS(A:A,A:A,">=0.5",A:A,"<=0.99") =SUMIFS(A:A,A:A,">=1",A:A,...
Hi Scotty I agree with Mynda. Multiplying the values by 1M is very risky. Anyhow if you just want to format the values (not changing the actual ...
Hi Alan Yes you are right. I check the inner most functions first i.e. MAX and MIN. Then combine it with OR and recheck before combining it w...
Hi Alan I suggest you split each formula into different cells first. This will allow you to check each formula to see if it is returning the cor...
Hi Trond Your attachment is not clear enough. There are no values in sheet 2. Please give examples of your expected result and where you got the...
Try this =IF(OR(MAX(G15:XFD15)>3.5,MIN(G15:XFD15)<-3.5),"VISIT","") Sunny
Hi Trond Unable to download your attachment. Can you try to upload it again?
Hi Cara Try this. In cell N2 enter =IF(COUNTIFS($C$2:C2,C2)=1,1,0) Drag down as many rows as needed. Hope this helps. Sunny
Hi Doug Try this: In cell Q3 enter this array formula (CTRL+SHIFT+ENTER) and drag down to as many rows as needed. =INDEX($B$1:$N$1,SMALL(IF(INDI...
Glad to know it is working. Cheers Sunny