#excel formula

Hi Everyone, Need a quick solution. I have a drop down list in in cell A1 with months name as text. If someone select any month from the drop down list. I want in cell B5 next month's name. Suppose if someone chooses in cell A1 "January" from the drop down list then in cell B5 February should...

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

# HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST i try target this Drop-down list but not working my Index+match formula .... pleased help this ......& Do Correction my formula.....

# How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"

I work in entertainment and media field and here there is something called Broad Cast Calendar which is very different from ISO standard calendar. Here they make changes to calendar such that every month has almost same number of weeks and every week starts with a Monday and ends on Sunday. I...

Hello, I need to combine if and sumifs function for this case that i have. (according to my lecture) The case is : to fill product cost column (Sheet 1) , they asked me to put the sum of unit price ( in Sheet 2) if the product type (Sheet 1) is Manufactured. If the product type is Bought-in...

Hello, Iam preparing a team productivity report, column A, shows days of that month in MM-DD-YY format and column B shows the number of transaction processed on the day which is mentioned in columns A. I want a formula which will add the vol if the day is Sat with the previous day i.e with...