Hi Jon You can refer the article below: Hope this helps. Sunny
Hi If the values from rows 3 and below are manually entered, then it can't be auto change when you update E1 to J1. You will need a macro and it...
Hi Alan Give this a try. Sub DelRow() Dim FirstRow As Long Dim LastRow As Long FirstRow = Application.Match("++++*", Range("F:F"), 0) LastRo...
See if this is what you want. 1) Copy E1:J1 (where your values 190, 275 etc are) 2) Select E3:J20 (or whatever the range of your customer's data...
Hi Mohamed What do you want to do with the data? What calculations do you require?
Please attach some sample data and the expected result.
There are many ways you can do that. A simple VLOOKUP or INDEX/MATCH should be enough.
Just right-click on the row label and select Group Then select Months and Years
Hi David The problem is your Net Due Date1 is not a true date but text. Just put a formula in column H example =G2 Custom Format the column G...
Hr Frans Please refer attachment. Sunny
Hi David In cell E2 enter : =IF(DAY(D2)<=15,"Mid","End") Hope this helps Sunny
You can refer here for more details : Sunny
Hi Hanson Please refer attachment. I am calculating for 3 months (3 days before expiration) It should work for any date. Hope this helps ...
Try this =SUMPRODUCT(C2:C10,CHOOSE({1;2;3;4;5;6;7;8;9},B2,B3,B4,B5,B6,F2,F3,F4,F5)) You should get the answer 793 Sunny
Hi Paul I assume your list is selected via Data Validation. I have 3 suggestions: 1) Just use an IF combine with a MATCH (or VLOOKUP) next to...