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 in Others by Kithuzzz
• 28,900 points
42 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 by narikkadan
• 53,520 points

Related Questions In Others

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
• 53,520 points
154 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
• 53,520 points
597 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
• 53,520 points
202 views
0 votes
1 answer
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,630 points
215 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,630 points
395 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,630 points
177 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
• 22,960 points
165 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
• 53,520 points
75 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 4 days ago in Others by narikkadan
• 53,520 points
30 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