Creating Formula to help sort values from one table to another

Y

yessir

Board Regular
Joined
Jun 7, 2019
Messages
103
Office Version
  1. 2021
Platform
  1. MacOS
Is it possible to create a formula where I would be able to generate values in the (sample) table I've entered below. However, the formula would need to be able to distingush the values in column A and when it changes from xxxx to yyyy. The main objective of this formula would be to count how many cars are in the lot at every given minute within the timeframe. Additionally, if the value in Column E is true the formula should disregard the data within that row.

DATA:
[TABLE="width: 240"]
<colgroup><col width="64" style="width: 48pt;" span="5"><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]A[/TD]
[TD="width: 64, bgcolor: transparent"]B[/TD]
[TD="width: 64, bgcolor: transparent"]C[/TD]
[TD="width: 64, bgcolor: transparent"]D[/TD]
[TD="width: 64, bgcolor: transparent"]E[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1
[/TD]
[TD="bgcolor: transparent"]///[/TD]
[TD="bgcolor: transparent"]16:01[/TD]
[TD="bgcolor: transparent"]16:28[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1[/TD]
[TD="bgcolor: transparent"]///[/TD]
[TD="bgcolor: transparent"]16:08[/TD]
[TD="bgcolor: transparent"]16:13[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2[/TD]
[TD="bgcolor: transparent"]///[/TD]
[TD="bgcolor: transparent"]16:08[/TD]
[TD="bgcolor: transparent"]16:33[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2
[/TD]
[TD="bgcolor: transparent"]///[/TD]
[TD="bgcolor: transparent"]10:05[/TD]
[TD="bgcolor: transparent"]16:26[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2[/TD]
[TD="bgcolor: transparent"]///[/TD]
[TD="bgcolor: transparent"]16:02[/TD]
[TD="bgcolor: transparent"]16:11[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
</tbody>[/TABLE]

SAMPLE TABLE:
[TABLE="width: 768"]
<colgroup><col width="64" style="width: 48pt;"><colgroup><col width="64" style="width: 48pt;" span="15"><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
[TABLE="width: 768"]
<colgroup><col width="64" style="width: 48pt;"> <col width="64" style="width: 48pt;" span="15"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]16:00[/TD]
[TD="width: 64, bgcolor: transparent"]16:01[/TD]
[TD="width: 64, bgcolor: transparent"]16:02[/TD]
[TD="width: 64, bgcolor: transparent"]16:03[/TD]
[TD="width: 64, bgcolor: transparent"]16:04[/TD]
[TD="width: 64, bgcolor: transparent"]16:05[/TD]
[TD="width: 64, bgcolor: transparent"]16:06[/TD]
[TD="width: 64, bgcolor: transparent"]16:07[/TD]
[TD="width: 64, bgcolor: transparent"]16:08[/TD]
[TD="width: 64, bgcolor: transparent"]16:09[/TD]
[TD="width: 64, bgcolor: transparent"]16:10[/TD]
[TD="width: 64, bgcolor: transparent"]16:11[/TD]
[TD="width: 64, bgcolor: transparent"]16:12[/TD]
[TD="width: 64, bgcolor: transparent"]16:13[/TD]
[TD="width: 64, bgcolor: transparent"]16:14[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]




[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"]
[/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"]
[/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
yessir said:
Is it possible to create a formula where I would be able to generate values in the (sample) table I've entered below. However, the formula would need to be able to distingush the values in column A and when it changes from xxxx to yyyy. The main objective of this formula would be to count how many cars are in the lot at every given minute within the timeframe. Additionally, if the value in Column E is true the formula should disregard the data within that row.

DATA:
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]A
[/TD]
[TD="width: 64, bgcolor: transparent"]B
[/TD]
[TD="width: 64, bgcolor: transparent"]C
[/TD]
[TD="width: 64, bgcolor: transparent"]D
[/TD]
[TD="width: 64, bgcolor: transparent"]E
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1
[/TD]
[TD="bgcolor: transparent"]///
[/TD]
[TD="bgcolor: transparent"]16:01
[/TD]
[TD="bgcolor: transparent"]16:28
[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1
[/TD]
[TD="bgcolor: transparent"]///
[/TD]
[TD="bgcolor: transparent"]16:08
[/TD]
[TD="bgcolor: transparent"]16:13
[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2
[/TD]
[TD="bgcolor: transparent"]///
[/TD]
[TD="bgcolor: transparent"]16:08
[/TD]
[TD="bgcolor: transparent"]16:33
[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2
[/TD]
[TD="bgcolor: transparent"]///
[/TD]
[TD="bgcolor: transparent"]10:05
[/TD]
[TD="bgcolor: transparent"]16:26
[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2
[/TD]
[TD="bgcolor: transparent"]///
[/TD]
[TD="bgcolor: transparent"]16:02
[/TD]
[TD="bgcolor: transparent"]16:11
[/TD]
[TD="bgcolor: transparent"]FALSE
[/TD]
[/TR]
</tbody>[/TABLE]

SAMPLE TABLE:
[TABLE="width: 768"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]
[TABLE="width: 768"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"]16:00
[/TD]
[TD="width: 64, bgcolor: transparent"]16:01
[/TD]
[TD="width: 64, bgcolor: transparent"]16:02
[/TD]
[TD="width: 64, bgcolor: transparent"]16:03
[/TD]
[TD="width: 64, bgcolor: transparent"]16:04
[/TD]
[TD="width: 64, bgcolor: transparent"]16:05
[/TD]
[TD="width: 64, bgcolor: transparent"]16:06
[/TD]
[TD="width: 64, bgcolor: transparent"]16:07
[/TD]
[TD="width: 64, bgcolor: transparent"]16:08
[/TD]
[TD="width: 64, bgcolor: transparent"]16:09
[/TD]
[TD="width: 64, bgcolor: transparent"]16:10
[/TD]
[TD="width: 64, bgcolor: transparent"]16:11
[/TD]
[TD="width: 64, bgcolor: transparent"]16:12
[/TD]
[TD="width: 64, bgcolor: transparent"]16:13
[/TD]
[TD="width: 64, bgcolor: transparent"]16:14
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 1
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Lot 2
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]0
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[/TR]
</tbody>[/TABLE]



[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...


Any kind of vague direction is appreciated.
 
Upvote 0
Try this


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:45.62px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:50.38px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /><col style="width:38.02px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Lot 1</td><td >///</td><td style="text-align:right; ">16:01</td><td style="text-align:right; ">16:28</td><td >FALSE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Lot 1</td><td >///</td><td style="text-align:right; ">16:08</td><td style="text-align:right; ">16:13</td><td >FALSE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Lot 2</td><td >///</td><td style="text-align:right; ">16:08</td><td style="text-align:right; ">16:33</td><td >FALSE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Lot 2</td><td >///</td><td style="text-align:right; ">10:05</td><td style="text-align:right; ">16:26</td><td >FALSE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Lot 2</td><td >///</td><td style="text-align:right; ">16:02</td><td style="text-align:right; ">16:11</td><td >FALSE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td style="text-align:right; ">16:00</td><td style="text-align:right; ">16:01</td><td style="text-align:right; ">16:02</td><td style="text-align:right; ">16:03</td><td style="text-align:right; ">16:04</td><td style="text-align:right; ">16:05</td><td style="text-align:right; ">16:06</td><td style="text-align:right; ">16:07</td><td style="text-align:right; ">16:08</td><td style="text-align:right; ">16:09</td><td style="text-align:right; ">16:10</td><td style="text-align:right; ">16:11</td><td style="text-align:right; ">16:12</td><td style="text-align:right; ">16:13</td><td style="text-align:right; ">16:14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Lot 1</td><td style="text-align:right; ">0</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Lot 2</td><td style="text-align:right; ">1</td><td style="text-align:right; ">1</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">3</td><td style="text-align:right; ">3</td><td style="text-align:right; ">3</td><td style="text-align:right; ">3</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td><td style="text-align:right; ">2</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B10</td><td >=COUNTIFS($A$1:$A$5,$A10,$C$1:$C$5,"<=" & B$9,$D$1:$D$5,">="&B$9,$E$1:$E$5,'FALSE')</td></tr></table></td></tr></table>
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Help Please
2 3
Replies
21
Views
486
Asbestos_Jen
Asbestos_Jen
srizki
  • Solved
Formula - Drag down to get values from the same row.
2
Replies
13
Views
160
Peter_SSs
Peter_SSs
Seafox
  • Question Question
Glide Path Calculation
Replies
3
Views
159
RobP
R
A
  • Solved
Extract the require data from Sheet1 to Sheet2 (Total Consumption For an Item for a period in Sheet1 For Several Items) in another sheet2 get in deta
2
Replies
10
Views
220
DanteAmor
DanteAmor
N
  • Question Question
Marco, IFS and XLOOKUP but certainly happy to be wrong
Replies
2
Views
440
N0t Y0urs
N

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top