1. A

    Want to know formula regarding excel

    Hi Experts, I am working in a consultancy firm where I am dealing with different types of clients at the same time. I am using excel 2016. My concern is there any type of formula or any other function which helps me to check when I open and close the excel file includes all specifically day...
  2. V

    Making a Bar Graph from Unsual Data Format

    I am trying make a bar graph of the data shown below. The x-axis should be "Years" and the y-axis, should be "INCOME," "SPENDING," and "TIPS." In my attempt below, it can be seen that "TIPS" are not following the correct "Years" input. I created this graph be using the Graph Wizard in Excel...
  3. T

    SumIfs' formula with Multiple criteria including dates

    Hello, Hopefully somebody can help me, I am trying to creating a sumifS formula or something I am looking to sum Qtys by date and item number from one sheet and match up to the item on a separate sheet: Sheet1 looks the following: A | B| C | D |...
  4. P

    Help cell refernece not to delete when delete columns on another sheet

    HI can someone help. i have a formalu below =IFERROR(INDEX('sheet2'!$A$5:$S$32,MATCH('sheet1'!B19,'sheet2'!$A$5:$A$17,0),5),"") however when i need to add/dleete some columns in sheet2 and but i want it to stay and look at the above, but when i add/delete the columns the cells it is...
  5. R

    If Vlookup is true return a different cell's value.

    I'm looking to be able to run a vlookup or something similar that would check if the requested cells value is there but if it is then it should respond by showing the value of a cell from another column rather than the one it's looking at. What's the best way of doing this? Thinking maybe it...
  6. K

    Need help on formatting cell value

    Hi Friends, I am looking for help to convert values FROM: <tbody> 05-01-2018-01.15 </tbody> TO: 05/01/2018 01.15 AM Appreciate your help on this Thanks Khuharshree
  7. C

    cross reference between 2 sheets in same workbook

    I work with audit rules that are being populated from a financial database (Concur) into an excel sheet. There are different rules being applied to different organizations. I need to compare the overall data in sheet2 that has the names of the codes for the organization that are auto populated...
  8. D

    In a Time Formula convert into Whole Number in same cell formula Struggling

    HI Guys Please see attached image re problem I have question written on image I have added the Spreadsheet here as well PLease can you help
  9. S

    Formula stopped working

    So I am pulling out my hair here, trying to figure out why over the last two months, this formula has been working, and now it stopped. I have duplicated my previous work to the letter, I have double, triple, and quadruple checked my data sets. I have named and re-named my ranges to ensure they...
  10. R

    General Excel Formulas

    Good Morning, all. I'm a beginner with Excel and would like some help in figuring out the proper formula for the screenshot below. What I'm trying to do is be able to put in total Gross Profit for each day of the month and then have Excel tell me what I'm pacing to hit in Gross Profit at the end...
  11. S

    Vlookup Extract Keywords and make a list in a different worksheet

    Hello My question is. I have a sheet lets say Called "Inventory" there I have 10,000 items with information from UPC, Name, Cost, etc. i don't want to use the sort for specific items so I created another sheet which I'll call "toilet paper" I want that this sheet should search in sheet...
  12. F

    Quarter and Month Formulas

    Hi All, Please can someone help me on the below. Can a formula be used to pick up the different months in a quarter? Say I have Q1 in cell A1 and I want cell A2 to pick up the first month of the quarter, A3, the second month of the quarter and cell A4 to pick up the third month of the...
  13. O

    Lookup multiple values in a single cell (separated by commas) and then return the values to a single cell (also comma separated)

    <tbody> Purple! Pink! Gold! Nude! Orange! Yellow! Brown Ivory! Black! Green! Silver! Purple! Pink! Nude Purple! Pink! Gold! Nude! Orange! Yellow! Brown </tbody> Above are values & we have another sheet of categories. In categories there are numbers like below <tbody> Red 17 White 18...
  14. Manolocs

    Add Full stop to all cells

    I have this extensive list some of it already have a full stop at the end of the phrase, I need to insert the (.) at the end of the cells that do not have full stop already. Any help is more than welcome. If possible with formulas would be very appreciated. Thanks in advance
  15. R

    HELP! Formulas assistance

    i have an excel formula below that i need to add a column to after each day of the week,. How do i write/adjust the formula to give me what i need...
  16. K

    Convert text to date format

    I have a column consisting date details. But its just entered as texts. How do I make it to a date format. Thank you very much for your valuable time.. <tbody> July 17, 2015 August 4, 2015 August 23, 2015 July 21, 2015 July 13, 2015 October 18...
  17. M

    Help with symbol

    Can someone tell me what the symbol ^-1 means as I am trying to work out a formula =IF(ISERROR((((B7*0.48888)^-1)-(371^-1))^-1),0,(((B7*0.48888)^-1)-(371^-1))^-1)
  18. J

    Return the Questions Answered Incorrectly on a Quiz

    Hello, I have a test I've created for new hires, and I need to identify which questions are answered incorrectly based off an answer column. <tbody> Question: Result: 1 correct 2 correct 3 wrong 4 correct 5 not answered 6 wrong 7 wrong 8 correct 9 correct 10 not answered...
  19. I

    Allow only characters, numbers and spaces in a cell

    Hi, I am stuck with a data validation problem. I need to validate a cell to allow only characters, numbers and spaces with maximum length of 40 char e.g. My room no is 402. I have this formula =AND(SEARCH(MID(I3,ROW(INDIRECT("1:"&LEN(I3))),1),String),LEN(I3)<=40) but it doesn't allow space...
  20. S

    How to Caculate Accuracy

    I am trying to determine how accurate a forecast is. For example, a customer requested 18 items. However, they only pick-up or take 6 items. The forecast of their needs is only 33.3% accurate. 18 forecasted 6 actual 33.3% accuracy Calculating a formula that can handle the reverse scenario...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back