excel function

Hello, Hoping someone can assist me with this excel question. I would like to create List3 as it looks. If the color in List2 is in List1, then I want it to show up in List3. The part I am stuck on is getting List3 to pull green to the first row,, blue to the second row, and so on. Appreciate...

Excel experts!! I need you help... I have a long list of names that I want to copy over to another sheet, however, I want the names to be in every other row on the other sheet. Is there a way to do this with a formula, as the list will continue to grow and I want the other sheet to...

Hello, I want to search for the Label ID in multiple sheets within a workbook. For example, I want to search for "WD734895" in cell A2 in Book1 within the contents of the workbook 2024.01.xlsx and in all sheets within that workbook. Once it is found, I would like to return the cell value that...

I am looking for data in a table if it exists, and I use Ctrl + F to manually find the data within the table. However, I am wondering if there is a way to use the combined Excel functions such as Index, Match, & Address (or any other function). The data to look at is in Sheet 1, and the lookup...

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.

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

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.

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

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

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

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),"")...

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

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

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

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

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

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

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

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

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