Excel - Stack Data based in Condition

0 votes

I want to stack a table based on this condition

enter image description here

I want to automatically stack every instance of "Available" on the table that is running for at least 4 minutes (screenshot above)

This is a reference to the table.

enter image description here

Only this 8-minute running should appear on the stacking table as there is currently only 1 "Available" running greater than 4 minutes out of 3 "Available" who did not meet the criterion (on the 1st screenshot)

I hope I made my points clear.

Only 1 result can be displayed because I can only use MAXIF based on the table's "Available" requirement.

enter image description here

I want all "Available" that has running 4minutes and up to be listed and stacked on the table automatically and it should show blank if everyone is below 4 minutes.

Jan 14, 2023 in Others by Kithuzzz
• 38,000 points
381 views

1 answer to this question.

0 votes

Try this :

=TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss")

It appears you tried Filter but you should not need to change anything as it is dynamic. I hope this helps you.

answered Jan 14, 2023 by narikkadan
• 63,640 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,640 points
758 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,640 points
2,551 views
0 votes
1 answer

Runtime error 438 while importing data in excel from secured website using VBA

Replace With ieDoc.forms(0) .userType.Value = "1" ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,640 points
874 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,888 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,967 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
959 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,616 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,640 points
1,081 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

answered Feb 4, 2023 in Others by narikkadan
• 63,640 points
899 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP