1. G

    Need Assistance with either a Formula or VBA.

    Hi! I've been working on a report and I'm currently stuck on a section in which I'm trying to pull the qty order numbers are listed from one sheet and paste that qty on another. I've been trying to use formulas to make this work but i cant seem to get it done, I've used countifs, sum, and...
  2. E

    Search based on multiple conditions.

    hello there, i would like to know if excel could apply search based on multiple condition and return a specific value that match with all conditions and there is the assumption. if i work in a bank and the bank sometimes do investigations to some customers to check their valid to have a credit...
  3. A

    Storing unused values in array(?) for later use in formula

    Hello all - I have a question, please: Col A has values. Col B checks a condition and returns true or not ("Y"). If Col B returns TRUE, Col C stores Col A's value. Col D repeats the stored value so that: Col E can check Col D against a different condition, and returns TRUE or not. This...
  4. S

    how to replace a cell num value with another cell num value by using a formula?

    Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...
  5. Jyggalag

    Conditional formatting for blank cells containing formulas?

    Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...
  6. 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...
  7. 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...
  8. 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 |...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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
  20. 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...

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