find()

  1. L

    Help with FIND() function in PowerPivot

    I have a table in PowerPivot that is pulling a value from a related table using the related Function. I’m then trying to test if that value is 1 of 4 values, and if so, return a value from another related table, otherwise return a value from another column within the same table. For example, I...
  2. J

    how do i merge down a sum of formulas into one function

    ok i have written down this =LEFT(A1,3)&MID(A1,FIND(" ",A1)+1,3)&MID(A1, FIND(" ",A1,FIND(" ",A1)+1)+1, 2)&RIGHT(A1,2)&TEXT(MONTH(TODAY()),"00")&RIGHT(YEAR(TODAY()),2) i put these formulas together to generate SKU for my store. I wanna turn this into a function named SKU(), for easy access in...
  3. D

    My ‘RIGHT / FIND’ function works but I don’t know why

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Excel 2013 - I inserted a function in my spreadsheet that, after experimenting with, I got it to work but I don’t understand why and I’m hoping someone can explain this to me. I...
  4. TheRiddler

    FIND() a specific rank based on rules!

    Hello everyone, I'm trying to build a reporting spreadsheet so I can manage some of my team members grades (which can be from 1 to 10). This will help me with an AVERAGE() formula formatted to show a percentage of satisfaction from clients/colleagues :) Now, I have the following table...

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
Back
Top