OK see if this is what you wanted.
Just enter a date into cell D2 which correspond to the 1st Monday of January. In my earlier attached file, 1/1/2018 happens to be a Monday. All the...
Hi Irfan Give this a try. What I am doing is counting the Emp ID in column A to see if it already exist (If count is >1 then already exist) ...
Hi Cindi Thank you for your file. Please refer attachment. I have modified your service code table to include the rates. Hope this helps. ...
Hi Michael It would better if you can attach some sample data in a worksheet and describe what you have done and what you wanted. It will make i...
Hi Sholtan See attachment. Assumption is you are only comparing 9 columns (A - I). Hope this helps. Sunny
Hi Arif I am assuming you want all the conditions to be true. Try =AND(DNZ=12,YDS=36,PCS=1) where DNZ, YDS and PCS are cell addresses. You...
Hi Cindi There is no attachment. For Q1 you can try =IF(OR(A1="DSI",A1="DSG"),1,4)*B1 Where A1 is your service code and B1 is your hours. ...
Hi Shreyas It is not clear from your description what you wanted. Can you please attach a sample file with the expected result? Highlight the ex...
Thanks for your feedback. Glad to know it is working for you. Sunny
Hi Sam If you have the assets age in a column then you could try using the RANK function to do what you wanted. You can learn more about it here...
Hi Paul Please refer attachment. The formulas are ARRAY formulas and need to be completed by CTRL+SHIFT+ENTER instead of ENTER. The curly bra...
Hi Paul Give this a try. Sunny
Can you show us what your expected answer is like?
There is no duplicate data in your attachment. Highlight to us (if any) which are duplicates. If you are using Excel 2010, you can use the Data - R...