excel & formula

Hi Forum, Hope you can help. I have a worksheet updating every Monday with result from the previous week using VBA and appends to the right of the last entry. When a month is complete I am then required to report the average of the data points - each day has 24 data points for each hour so...

Would you know what is the correct match function with wild card. I have three sheets in one work book. They all do not have the same product description, all three sheets have the same header columns. I tried to use sheet1 and sheet two for the cell match Total (Qty) from both into Sheet3...

Hello, I have a problem to solve regarding placing the orders for materials before the material runs out from the stock. for example in the image below, row 2 shows the demand per week of part x. Row 3 shows the stock inventory after consuming the week's demand plus the shipment received in that...

This is 2nd Friday of Feb. Date: 2/10/2023 Returns First Friday of the current Month. =WORKDAY.INTL(TODAY()-DAY(TODAY())+1,1,"1111011") What formila will tell what friday it will land on. (Want the formila to tell me if it will land on 4/7 or 4/14. The correct date is 4/7) I could create it...

Good afternoon all. Have a tricky goal to try and combine two rows with the same data, so merge it into one row of data. I will need a formula that can combine them as ill have lots of this data coming in. As you can see below - A, B and C all share the same data and i need them merged into...

I'm a little stuck on a project. Sheet 1 has a list of people Sheet 2 has a list of people Sheet 3 needs to compare the lists in Sheets 1 and 2 and list the differences between them. I'm not sure of the syntax, and how to write the indirect formula to do this ? Any help would be greatly...

Good afternoon, I am in need of a formula that will identify the month name in one column from the month number is another column. To be specific, I need the "MONTH" column to show the abbreviated month name using the number in the "MONTH #" column. Any help would be greatly appreciated...

is it possible to convert a excel value from date number to date via vba or formula where the input is 1 to 365 and leap year 366 to a output of month and date number for example 104 as date number and date for 2023 will be april 14. i couldnt figure out how so i haveno code to start with whatsoever

Hello, I want to merge two columns - column R and column S. Few data is in column R and few data is in column S. Is there any way or formula to merge the columns?

In the column A there are data. I'm asking for advice. I need to extract data between two expressions in a string and the condition is met that three lines in a row contain: 1st line "<CATEGORY_ID>" 2nd line "<CATEGORY_NAME>" 3rd line "<CATEGORY_FULLNAME>" AB1<SOMETHING>4562<CATEGORY>Snow...

Hey guys, Struggling here with a big project of mine and really need some help! So the data i get in has two columns, a and b. In a it provides me with two answers either yes or no. This tells me if this was planted or not. Column b provides me with my trees data tag. i need to find a way to...

Hey Everyone I've been trying to figure out how to write this formula and I'm open to using VBA if need be but I'm super new to it so my knowledge is limited. Summary: I'm trying to get CELL = [sheet2] X but if X is Blank then CELL = [sheet2] Y, if Y is Blank then CELL = [sheet2] Z, and if...

Dears, I need a "conditional formatting" to get highlighted if all the information are matching in all 3 tables like in the sheet.

I had searched a searchable database in Excel for a long time. For example, I found this one which is quite useful: https://www.thespreadsheetguru.com/blog/filtering-search-box What I found is that there are many ways to create a search box or search boxes with VBA or with Formula. However...

=INDEX(Table!$B$3:$E$450,MATCH(A2&"Schedule 3"&"PLACE 1",Table!$E$3:$E$450&Table!$C$3:$C$450&Table!$F$2:$F$450,0),1)

Hello all, Data at M4,L4 change every 5 days: 1-5,6-10...,26-end Day 01Feb, at E6=$M$4, E7=$L$4, Day 06Feb, at F6=$M$4, E7=$L$4 ... Day 26Feb, at J6=$M$4, E7=$L$4 How can use vba or formula to change data of E6,F6..J6 follow M4,L4. Thank all ABCDEFGHIJKLM1 KẾT QUẢ SẢN LƯỢNG VÀ ĐƠN GIÁ 2023...

I need to build a procedure in vba that looks in a column range - (example $B$2:$B$8) - and check if any of those cells contain the chars '*' OR '#', in order to get the Row where the first match/partial match happens. I've adapted a code presented on this site by Rick Rothstein, where the...

Hi I stupid question I have the below formula (which works as i need it) =SUMPRODUCT(--('2023'!$I$2:$I$398>=Totals!$C$2),--('2023'!$I$2:$I$398<=Totals!$C$3),--('2023'!$B$2:$B$398=Totals!A5)*('2023'!$J$2:$J$398=other!$N$5)) I need it to show blank or a - if it is Zero is there a simple way to...

In the attached workbook there is about 5 sheets, i'm using this formula to extract all unique records in column B only in sheet (5) based on a criteria in main!D2 =IFERROR(INDEX('5'!$A$1:$A$2222, SMALL(IF(ISNUMBER(MATCH('5'!$B$1:$B$2222,$D$2, 0)), MATCH(ROW('5'!$B$1:$B$2222)...

I have a sample like this: dataset I tried to get the earliest login time for certain date and certain agent: I am not able to get the result I want. can someone give me a guidance? dataset Thanks,