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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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

R
  • Question Question
Help Formula Countif or Countifs
Replies
6
Views
79
Cubist
Cubist
L
  • Solved
Help Please
2 3
Replies
21
Views
532
Asbestos_Jen
Asbestos_Jen
M
  • Question Question
#Value Error - Please Help
Replies
3
Views
66
Alex Blakenburg
A
srizki
  • Solved
Formula - Drag down to get values from the same row.
2
Replies
13
Views
169
Peter_SSs
Peter_SSs
Seafox
  • Question Question
Glide Path Calculation
Replies
3
Views
199
RobP
R

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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