Hi Anders I think you will also need to check A1 for leading and trailing space. So another criteria is LEN(TRIM(A1))=2 Sunny
Hi Gayla You mentioned: Let's say these cells can only have 2 characters / some I have will have 3 or 4 Words. Did you mean 3 or 4 characters...
Hi Ehab Hope you don't mind a VBA solution. Sub GetCompetitor() Dim LastRow As Long Dim StartRow As Long Dim i As Long Dim j As Long LastR...
Hi Ehab Unable to download the file. Can you try attaching the file again?
Hi Pam In cell B2 enter =IF(ROW()=2,1,IF(A2=OFFSET(A2,-1,),OFFSET(A2,-1,1),OFFSET(A2,-1,1)+1)) Hope this helps. Sunny
Hi Tom I agree with what Anders said. Your data is pretty messy with a lot of merged cells and need to be "cleaned". You mentioned that the form...
It is difficult to give an exact answer as we don't know if the sheets you are copying contains only data or it includes formulas as well. Why don...
Hi Ellen You can try using Data Validation and VLOOKUP. See if this help. Sunny
Give this a try.
Maybe this: =MROUND(EndTime-TIME(18,0,0),"0:30") Where EndTime is the time the worker finish work. If this doesn't work then perhaps you coul...
Hi Sim Che You can try putting the values into a table and do a VLOOKUP to get the OT hours entitlement. See example attached. Hope this help...
Hi Aye Mu I still don't understand the logic to calculate the amount. This is as close as I can get. Not sure whether which of our answers are c...
Furthermore how do you get the highest rate? If there is only 1 line then the highest rate in at the line itself.
Hi Aye Mu Can you please recheck your attachment? I think your proposed answers are inaccurate. Make sure that your proposed answers are all cor...
In cell L2 enter =IF(COUNTIFS($D$2:D2,D2,$B$2:B2,B2)=1,H2,L1) Hope this helps. Sunny