# excel function

1. ### 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.
2. ### 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.
3. ### 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...
4. ### 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...
5. ### 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),"")...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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"...
11. ### 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...
12. ### 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
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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)...
18. ### 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...
19. ### Sales Targets and Commission

Hi Everyone, I am looking for advise on how to analysis sales targets and commission on daily bases. The table below is the one I had for a month but I would like to do break down on daily bases to track activity of my team on daily and weekly bases as well grant compensation...
20. ### COUNTIF Based on Two Criteria

Hi Everyone, First, a bit of background. I have access to a database that provides me with engine status codes for a vehicle with a time stamp. This engine status code is in decimal, but needs to be converted to binary to be read because each engine status (No Engine Speed, Engine Derate, and...

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

### This Week's Hot Topics

• link pictures from Sharepoint to Excel macro
Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
• lookup match return closest to x date
Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
• Average hours per week
I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
• Identify equipment used -No of consecutive days
Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
• Filling in data from source
Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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

### Which adblocker are you using?

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

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