Table not appering need formula

santoshloka

Board Regular
Joined
Aug 31, 2017
Messages
125
D5=1 , 1cells need to appear as well as 1 tabular form need to appear
D5=2 , 2 cells need to appear as well as 2 tabular form need to appear
D5=3 , 3 cells need to appear as well as 3 tabular form need to appear

i have used this formula,,it is working when the condition is met it is appearing

=IF(D5>=0,"Cell-1","")
=IF(D5>=1,"Cell-2","")
=IF(D5>=2,"Cell-3","")
=IF(D5>=3,"Cell-4","")

iam using this formula to apper Cell 1 in D8

there is a issue with tabual form,ito appear one table which formula i have to use

Example of tablular form U3:AD4 for Cell1
H(mm)QTYABDCEFKJ
2 3 5 5 58 8 8 8 7

<tbody>
</tbody>
This is one table

3more tables are there like this

can yu guys suggets formula or any macro
 
Last edited:

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
I cannot understand what you want. Do you want to retrieve a row of data from either table1, 2 or 3 ?
 
Upvote 0
1234row 1
length1000120014001600choice2
height100110120130
thick50556065row 4col I
col Bcol Ccol Dcol E
length1000
height100
thick50
if you change the choice to say 4, - four tables appear
length1200#####
height110
thick55
row 18
row 22
#####
=IF($I$2>1,C2,"")
change the 1 for 2 and 3 for the next two mini tables
pretty easy to change to row format if that is what you want

<colgroup><col width="64" span="15" style="width:48pt"> </colgroup><tbody>
</tbody>
 
Upvote 0
If possible can I get picture or workbook what yu have done I didn't understand

One table =U3:AD4
Second table=U6:AD7
Third table=U9:AD10
Forth table=U12:AD13

If I give D5 place 1
Only one table need to appear rest 3 tables need to hide or disable
If I give D5 place 2
Only One,Second table need to appear
...etc up to 4 only
 
Upvote 0
I take the choice you have entered - 2 in this case - and create two tables - the other two do not appear - I thought that was what you wanted....
 
Upvote 0

Forum statistics

Threads
1,220,965
Messages
6,157,120
Members
451,399
Latest member
alchavar

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