formula help

  1. X

    Formula to return the position of the last occurent character

    The title can be a bit hard to understand. English isnt my native language, so i am sorry. What i meant is this: I have a Cell with a value of, lets say, "1,2,3". Now i want the position of the last comma. In this case it would be the Position 4. How can i search for it with a formula?
  2. T

    Issue with formula not reading from a specific cell

    Hi all, I use a spreadsheet as a tracking doc to keep track of our process from project upload through client approval. The way the doc is set up is Column A (Name) has the name of task. Column B (OMIT) is where we log if a task has been omitted. Column D (Code) host the code I need help...
  3. S

    Formula Help: Possible Nested IF/AND issue

    I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated. If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’...
  4. Z

    Need Help Converting this Formula to Use CONCATENATE Instead of &

    I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...
  5. D

    Applying a set value to columns until the value is reached

    Hi and thanks for helping. I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3) If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4) If the deposit is applied, but there is a remainder...
  6. J

    Formaula Assistance

    I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...
  7. J

    If index match

    Hi all I could really do with some help as I can't get this formula right. I've been trying to use IF INDEX MATCH. IF A2 contains 2016 INDEX data from Column C MATCH H5 postcode with X5 postcode I basically have numbers in column C that I want listed in a new table, but only if cell A2...
  8. D

    Help with SUM formula based on data in separate table

    Could I get some assistance on a formula that I need in cell B11 below, where I'm looking to sum the total in column B for all of the units that are categorized as "old" (i.e. what's in cell A11) based on the table in F1:H7. <b>Excel 2013 64 bit</b><table cellpadding="2.5px" rules="all"...
  9. K

    Help!!! I have no clue where to start.

    I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...
  10. J

    Custom Data Validation Help

    Hi, I am trying to create a custom data validation and I need some help with the formula syntax. In my spreadsheet Column B has a drop down that says "Refund" and "Charge". I want to create the custom data validation in Column D to limit the number of characters in the cell so that any line...
  11. E

    PowerPivot: Add one product to another

    We are getting rid of some old products, and directing the demand for the old product to a new product. I am trying to setup a table which shows the change in demand for the new product. Here are some very simple tables which lays out what I am working with. I have a table called SKU_Mapping...
  12. S

    Frustrating Formula, Need Help!

    Hey there, Basically I have a tedious routine process that I think can be simplified by having excel do it for me in a formula. Only issue is that I'm not too great with these. Any help would be greatly appreciated!! The process is as follows: I receive a spreadsheet everyday with many...
  13. V

    Formula Help

    Hi, Can any one explain how to convert an excel content to html form which will help to code in macro. Ragrds, VK
  14. E

    Formula help - IF, OR, AND, VLookup? multiple conditions

    Hi all, I have the following fields of data: A2 'values': (shows the value 'low', 'mid' or 'high) B2 ' ratings': (shows a value rating of between 1-5) I need a formula to populate the %'s in the table below, based on the rating and value. I.e. If Rating is 1 and value is 'low' show 0, if...
  15. B

    Network Days & IF Statements

    Network Days & IF StatementsHi Guys, I hope you are all having a great friday I was just wondering if anyone could help me combine the power of Networkdays and IF Statement so currently I have a start Date In A1 and End Date in B1 then either AM,PM Or Full in C1 with the days total in D1...
  16. J

    Calculating Holidays

    I am needing to calculate holidays that I can use as part of the workday function. I used the following formula for Thanksgiving but need help understanding what it is doing so I can calculate these other holidays. =DATE(C2,11,1)+21+CHOOSE(WEEKDAY(DATE(C2,11,1)),4,3,2,1,0,6,5) --C2 is the...
  17. W

    Iferror formula help

    Hello. I need help creating a formula to compare and look for items between sheet1 and sheet2 below. Sheet1 is a report I can run to see what lines currently exist in our system. Sheet2 is an example of what the monthly invoice looks like. I need to determine what the line numbers are (from...
  18. E

    How to make a lookup Case Sensitive

    Hi, I am working on combining a list based on an unique Account ID's. But the formula needs to be case sensitive. I have tried the following formula but continue to get an error no matter what I do. I have never used an index formula before so this might be an easy fix that I am just not...
  19. G

    Date Outstanding - Requested, Responded and Today

    Hello, Is there a way to setup an excel formula to provide a day outstanding number? I need it to do the following: Subtract Date requested from todays date unless date responded is filled in. Thanks in advance, Grahfchart
  20. S

    VLOOK UP & Pivot Tables? HELP!

    Can anyone help with this formula? Its beyond me, but I have been told it can be achieved with Excel, I need a formula that I can input information to a specific job number, so when i change between jobs the information is store individually to the specific job number not sure if this a pivot...

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