excel function

  1. J

    How to sum the total for 1(1A) + 3(3A) + 5 = 9(4A) ?

    How to sum the total for 1(1A) + 3(3A) + 5 = 9(4A) ? other examples: 1(1A) + 3(2A) = 4(3A) 10(2A) + 1 = 11(2A) I need to sum at least 100 cells in the Excel (same column or same row). Thank you.
  2. J

    How to group or categorize data from one sheet to another when categories are unknown until data is pushed to output sheet

    Hello, I have a tool that spits out data to excel in a sheet with column headers and several rows of data. From that data, I'd like to transfer it to another sheet in a prettier format and grouped by a certain column based on the output. For example, I have a category column, for every repeated...
  3. N

    Is there any functions to make this statement in excel

    I have to make the statement based on column A and Column B; Please find the Image for detailed info; is there any formulas to make this statement in excel or VBA. Please help me it will very helpful to me.
  4. S

    how to generate decimal random numbers between -0.57 to 0.37 in excel

    Hi, how can I generate decimal random numbers between -0.57 to 0.37 in excel? Thanks.
  5. S

    Excel function for distinct count based on dates match

    Hello, I have data set where order ID's get created for every purchase transaction, whenever there is a change in transaction same order id gets updated and forms a new row. Now i wanted to distinct count how many orders i received per calendar day where the calendar dates sits out side of the...
  6. D

    Power Query - Hyperlink to file

    I have a power query setup that imports tables from all excel files in a folder. Is it possible to have a column that contains a link to the original excel file? [I have this working in a regular excel table using the hyperlink function (which uses the customer name to get to the correct...
  7. S

    Offset Match condition

    My output should have both the fruits which have value as true. For eg: For third row, Apple, Orange and Watermelon has the value as "True", but it is returning only first value. Formula i have used : =IFERROR(OFFSET([@Apple],[@[Offset Tower]],MATCH(TRUE,Table2[@[Apple]:[pineapple]],0)-1),"")...
  8. D

    Alternative to complex OFFSET Function

    Hi, I'm currently using an OFFSET function embedded in a SUMPRODUCT formula to calculate a multiple instances of a single production stream. The formula directly underneath "Total Volume" is the following...
  9. M

    Moving Data into one Row Based on ID and First Mention

    <colgroup><col><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody> Individual ID Last Name First Record Postal Code Attribute Group Attribute Start Date Step 1 Date Step 2 Date2 Step 3 Date3 Step 4 Date4 34376725 Aaron 10/21/2010 35205 Grants Mill Growth Track _4 Dream...
  10. T

    Function or macro to extract data from a unstructured cell containing text

    Hello I'm trying to find a way to extract a User ID from cells in a field called Metadata. The data is not in a similar format in each cell and I've been racking my brain trying to figure out how to easily extract the User ID to an adjacent cell so I can run it easily daily without having to...
  11. S

    Get the references from the cells that are not blank

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  12. T

    Excel Nested If, Or, Then function

    Hello, This is kind of a nested mess that I can't figure out. I'm looking for help because I don't have the skills to engineer this function. In cell Z2, (If cell X2 equals the value in W2, AND any of the cells P2/Q2/R2 have the value "Red" or the value "Orange", then put "Critical Attention"...
  13. J

    circular reference in excel

    Dear All Please have a look at the link of excel file attach . Till row no 980 everything is fine in column F But in row no 981 , the value in column F it does not add "Reheat Function" and so on please help...
  14. C

    Excel function to determine how many days in year YYYY

    Hello, I need to determine whether my daycount should be 365 or 366 depending on the year. For example in 2016 it was 366 and in 2017 it's 365. Is there a function which will do this? Thanks, Clare
  15. B

    Dynamic dependent List drop down in Excel

    Hello, I have a database of 3 columns. I want to create a 3 hierarchy drop down. My table is something like this. Each drop down is dependent on previously selected option. IMAGE : I want the drop down to look something like this. Database table would be updated time to time. Image...
  16. V

    Need help with excel simulation problem with the help of functions

    I am a novice in Excel functions.And have encountered this problem for my management science course.I would be grateful if someone can help me in it. the question is a part of the business simulation model.I need to find the function that can build - " after every 10 minutes, the server has to...
  17. V

    Countif and sumif in case of 2 ranges with VBA

    I can usethe countif and sumif functions in case of 1 range. But there are 2 ranges wherewithI have to work and I don’t have any idea. I would like to collect the uniqueconnect between elements of two ranges, count how many are them and how much isthe total of their values. See the example. Can...
  18. J

    Excel Help with related to Left Right Mid function

    The sample text data in my sheet are like the following, example Peter England, * Shirt / UK in a single cell. I need Peter England in a different cell Shirt in a different cell UK in a different cell. I am using the following function B1 =LEFT(A1,FIND(",",A1)-1) for getting Peter...
  19. G

    Vlookup with If statement Issue

    Hi Guys, I have a keyword data dump that has 2 of every keyword (one has data for desktops, one has data for smartphones) I would like to write a vlookup formula that will first check if the keyword is "desktop". If so, pull the corresponding rank (which would skip over the smartphone rows)...
  20. H

    Excel function that lists only non-zero/non-blank values in a column starting from a specific reference in a row/column

    I need to include a function in my C2 cell formula that will skip days with non-zero values and then list the next non-zero day (the day is also listed N times based on Col B value). <tbody> A B C 1 Mon 2 Mon 2 Tues 1 Mon 3 Wed 0 Tues 4 Thurs 0 Fri 5 Fri 1...

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