excel formula

  1. L

    SUMPRODUCT inside Dynamic Array with CHOOSE - impossible?

    Hi! So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product. As you can see the result is 0 for each row. This is just an example of my real problem with a report of 200K...
  2. R

    Excel Formula IF

    Hi Guys I have the following formula =IF(H2>=F2,"withinsla",IF(H2<F2,"slabreached")) The above formula works well I want to add the following in the formula if H2=Q2 ,"urgent" Thanks and Regards rakesh
  3. R

    Days Aging Formula (# of days overdue)

    I have a list of past due invoices. I have a PO Date (column f) and I am wanting to add a column for Aging Days (column H) that will tell me how many days have gone by from the PO date. In column I, I would like it to tell me if the invoice is past due or not past due. Any help would be...
  4. K

    How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ???

    How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...
  5. A

    how to Find the cell position of a Duplicated smallest values in a data set ?

    Hello every one .. If i have a data set like this one in the attached picture , Is there any way to find the positions as a result in column "P" by finding the the smallest values in column "O". Notes that there are a duplicated smallest values in different positions in the data set.
  6. K

    HOW TO WORK THIS FORMULA WITH DROP-DOWN LIST

    # 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.....
  7. K

    We Need Only TEXT Contain, How to possible in Excel Formula ????

    All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......
  8. M

    nested if statement for text search

    I have this if statement that calculates a due date for me, it works fine but I now have a new situation that created the need to modify to exclude the calculation if column E contains the work "Broker". =IF(K21<>"","N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),"")) Here is what I...
  9. E

    Finding the largest date in "mm.yyyy" format in a text (?) column.

    I have a spreadsheet in which I dump some data from SAP, which ends up looking something like this I then insert a formula in J2 which is supposed to find the latest date / month there is a registration for. However, it doesn't seem to be able to interpret values in column D as dates. What...
  10. C

    How can add custom text to a cell based on a specific entry in a different cell?

    My laboratory is capable of running 20+ different analyses, and we get contracts from about the same 15 companies to do a combination of these analyses. I created an Excel spread sheet to keep track of the work as it comes in, where columns are the 20 different analyses we can run, and rows are...
  11. K

    How to Possible match "List-1" & "List-2" Both number match & show Result "List-2" in item cell ???

    Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........
  12. G

    Keep a record of changing cell values in a column in Excel

    I have a column that uses VLOOKUP to bring in values from another sheet. I would like to save the precious value of any cell in this column to the corresponding cell in the next column whenever the cell value has changed. Example: Current values: Cell A1=1, A2=2 If VLOOKUP brings a different...
  13. M

    Formula/ method to sort data in Excel

    Hi, We manage admissions data back-end. Our applicants go through interviews with 2 interviewers and this data sample is automatically populated using MS forms and Power Automate. However, this is what we need for the compilation of data in our mastersheet. For every 2nd interviewer, we...
  14. K

    How to match same invoce no. & get data "FILE -1" TO "FILE -2" ...

  15. W

    Formula to calculate employee cost when total salary is given and industry average per employee is given

    Hi, Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee. Below are the details Average salary per Job level...
  16. K

    How to sum with unique Invoice Number wise ?????

    # How to sum with unique Invoice Number wise ????? - Pleased Solve this query for formula ......very usefully trick for sale bill fill. like single invoice & two or more products in this sheet... problem is how to sum product based on unique Invoice No. - Pleased Help !!!
  17. K

    Party name According how many invoice to Show count , But Not Show count Total Invoice

    Show Result : 3 (Pleased Show this Query........................................)
  18. K

    Query: How to count same party with unique Invoice numbers....

    like ... "SR FOODS LTD" two time make Purchase products. 1) how to count target Unique Invoice Number & same party Name ???????????????????????????????????????????????
  19. A

    Excel conditional formatting if two condition satisfies

    I have excel sheet, which has value stored as price in "D" column now, I want to highlight particular cell in column "D" which satisfies below 2 conditions XFB9<=0.02 which cell has highest value among cells that has fulfilled above condition (column "D") issue I find here in writing formula...
  20. A

    If formula based on date in another column

    Hello guys, Need your help in getting the Excel Formula based on condition, 1. If Column A = Current Month and Column B > Current Month then Result in Column C is >MO 2. If Column A = Current Month and Column B = Current Month then Result in Column C is MO 3. Rest should be mentioned as Nill...

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 MrExcel.com.
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 "mrexcel.com".
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
Top