excel & formula

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

I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...

s.no Register number name year 1 001 Sahul II 2 002 Mathesh II 3 003 Hari II 4 004 Siva II i have a user form which gets FROM and To from the user. Now i need to print that range of value based on the user input ,to the next worksheet. I need VBA code for this function for example...

Hello, I have a "LET" formula trying to use, however, i got an error whenever I put a text on the first column. This is use for data validation, so i can remove the unique values and it is based on the data from "Shift" then "Group" headers. Thank you in advance!