excel & formula

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

I have a problem with a very long nested if formula (~10 level deep) that contain even more logical And statement in 1 IF, and at each level return a formula i have tried the evaluation function but it return "2" directly Ex: =IF(...IF(...IF(...IF(...IF(...,1+1,)...))))) ; i want to get "1+1"...

I am struggling in creating formulas that allows me to build the following table. The formulas that I need to create should be on the cells highlighted in orange. Specifically, given: The number of employees on staff each month, i.e. “employees on staff” The number of “new tasks assigned”...

I have this simple sheet and I want to return the band that the lookup value falls into. In this example I would expect the band to be returned to be "I" because 135 falls in the range of 130 to 139.99 I just can't figure out what formula to use, I tried a variation of lookup and index match...

Good After Noon, Trust everyone is Good Preparing a small tool which helps me in Daily routine at my work. I have a data where i am creating a pivot table and need to report out the numbers to my Team where we stand. I have written a code so far where pivot table is getting populated with the...

Hi any remedy to make my excel faster? This is some sample of my excel formulas =xlookup = b5&c2, NAME&DATE, LEAVE,"") =xlookup = b6&c2, NAME&DATE, LEAVE,"") =xlookup = b7&c2, NAME&DATE, LEAVE,"") =xlookup = b8&c2, NAME&DATE, LEAVE,"") Then drag the formula until =xlookup = b55&c2...

Hi please help me for this VBA code. Sheet 1 is leave planner Sheet 2 is Data (name &date&leave) are all in there The native excel formula is =xlookup = b5&c2, NAME&DATE, LEAVE,"") And then drag it until =xlookup = b5&AG2, NAME&DATE, LEAVE,"") And also drag it down from =xlookup = b5&c2...

Hi all, I have built a report with some financial transactions checking. The scenario is, (col A) company "1" sends money to (col B) company "2" so the common value in column C will be "12" (cell A & cell B). But if the company "2" sends money to "1" then in column C we will have "21". What...