excel & formula

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,

Hi All, I have a power Automate flow setup that pulls an excel spreadsheet and then inserts data into the "import" Tab, However, on the other sheets I have formulas that change values. Is there a way to lock these down? This formula in Excel seems to move when data gets added to the import...

=IFERROR(INDEX(Table2,SMALL(IF(Table2[Off The Road]="No",ROW(Table2)-4),ROW(43:43)),5),"") i want it to work if Table2[Off The Road]="No" and Table2[Spare]="No" I'm not too good with the syntax. Any help would be greatly appreciated

Hi, Good day, I need to set automatic % calculation on the dollar amount between amount of collection over the GPR right after the percent collection section. How to do it in formula and VBA? Thank you so much for your help :)

Im trying to upload a container with boxes , so I need to tell the sheet how many boxes do I have and all the rows will be like (the first row 6,6,6,6,6,3) and I need to know in which row the product will end. Thank you.

Afternoon all The issue I'm having is populating the correct number of day under a working week especially when start / end date goes across months What I'm looking to do is, add the number of days the data range covers and input that number in week 1,2,3 etc. each date range is a task and...

I am attempting to find any gaps between a start and stop date/time range. Essentially time when there are no appointments in the schedule, this is a 24hr service and I am looking for "dead" time when there isn't a customer in the office. Currently I was attempting to use the...

I'm a teacher working on a huge data set in a multi-academy trust on pupil progression. My Excel is very rusty and I'd appreciate any help on trying to find the total number of all female sets (ability groups) in our schools. Here's a mock-up of the data. The real set has many more column...

Hi, I'm a teacher and I'm trying to put together some data for progression. I'd be really grateful if anyone could point me in the right direction. ABCDEF1Cohort IDSizeProgression2Coniston2233Derwent14114Coniston2255Coniston22216Derwent1414789Size of Cohort with biggest difference in...

I hope someone can help me! I want that when I enter a value in cell B3 (or B4), the triangle in cell F3 (or J4) moves along. Likewise, when I enter a value in cell C3 (or C4), the triangle in cell J3 (or Q4) will also move. And how to program when I have many TASK to do. It's too hard for me...

In column A, I've got a list of companies (non-public so no stock ticker symbols) and what I'd like to do is create a formula that launches a google/bing search that puts the name of the CEO in Column B. A B Acme =FormulaX? (A: search "CEO of" A)

Hi all, I currently have the following setup: Is there an easy way to SUM this for each date? I realize that I can do something like this: However, I would like to make a solution in column C if possible or something along these lines, as the above solution would require me to make a new...