Formula to get the range of certain Category

N

nazarene

New Member
Joined
Jun 25, 2015
Messages
43
Office Version
  1. 365
Platform
  1. Windows
Dear Sir,
Can you please help me to make a formula in excel with the following category?
in the table below , I want to get the height type for each item. example. Type "Independents (IN)" the height is 2.03, so the height type should be 6, because 0 to 6 the height type is 6, etc. , another example Type "Suspended Floors (SF)" the height is 6.01 so the height type is 8. can you do it to all the category"?
thanks in advance. I also put the screen shots, because i cannot -arrange as it is, as I cannot see also the attachment for excel files

ITEM NO. Type Height DESCRIPTION
type
IST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02 Stair Towers (ST) 8 6.0-8 Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03 Stair Towers (ST) 10 8.01-10 Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04 Stair Towers (ST) 12 10.01-12 Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05 Stair Towers (ST) 14 12.01-14 Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06 Stair Towers (ST) 16 14.01-16 Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07 Stair Towers (ST) 18 16.01-18 Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
IST-08 Stair Towers (ST) 20 18.01-20 Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
IST-09 Stair Towers (ST) 22 20.01-22 Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
IST-10 Stair Towers (ST) 24 22.01-24 Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
IST-11 Stair Towers (ST) 26 24.01-26 Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
IST-12 Stair Towers (ST) 28 26.01-28 Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
IST-13 Stair Towers (ST) 30 28.01-30 Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
IST-14 Stair Towers (ST) 32 30.01-32 Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
IST-15 Stair Towers (ST) 34 32.01-34 Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
IST-16 Stair Towers (ST) 36 34.01-36 Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
IST-17 Stair Towers (ST) 38 36.01-38 Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
IST-18 Stair Towers (ST) 40 38.01-40 Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
IST-19 Stair Towers (ST) 42 40.01-42 Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
IST-20 Stair Towers (ST) 44 42.01-44 Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
IST-21 Stair Towers (ST) 46 44.01-46 Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
IST-22 Stair Towers (ST) 48 46.01-48 Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
IST-23 Stair Towers (ST) 50 48.01-50 Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
IST-24 Stair Towers (ST) 51 50.01-Above Installation of Stair Towers (IST) above 50 m

IWG-01 Walkways (WG) 8 6.01-8 Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
IWG-02 Walkways (WG) 10 8.01-10 Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
IWG-03 Walkways (WG) 12 10.01-12 Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
IWG-04 Walkways (WG) 14 12.01-14 Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
IWG-05 Walkways (WG) 16 14.01-16 Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
IWG-06 Walkways (WG) 18 16.01-18 Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
IWG-07 Walkways (WG) 20 18.01-20 Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
IWG-08 Walkways (WG) 22 20.01-22 Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
IWG-09 Walkways (WG) 24 22.01-24 Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
IWG-10 Walkways (WG) 26 24.01-26 Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
IWG-11 Walkways (WG) 28 26.01-28 Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
IWG-12 Walkways (WG) 30 28.01-30 Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
IWG-13 Walkways (WG) 32 30.01-32 Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
IWG-14 Walkways (WG) 34 32.01-34 Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
IWG-15 Walkways (WG) 36 34.01-36 Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
IWG-16 Walkways (WG) 38 36.01-38 Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
IWG-17 Walkways (WG) 40 38.01-40 Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
IWG-18 Walkways (WG) 42 40.01-42 Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
IWG-19 Walkways (WG) 44 42.01-44 Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
IWG-20 Walkways (WG) 46 44.01-46 Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
IWG-21 Walkways (WG) 48 46.01-48 Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
IWG-22 Walkways (WG) 50 48.01-50 Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
IWG-23 Walkways (WG) 51 50.01-Above Installation of Walkways (IWG) , by means of scaffolds built above 50 m

ISF-01 Suspended Floors (SF) 8 6.01-8 Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
ISF-02 Suspended Floors (SF) 10 8.01-10 Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
ISF-03 Suspended Floors (SF) 12 10.01-12 Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
ISF-04 Suspended Floors (SF) 14 12.01-14 Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
ISF-05 Suspended Floors (SF) 16 14.01-16 Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
ISF-06 Suspended Floors (SF) 18 16.01-18 Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
ISF-07 Suspended Floors (SF) 20 18.01-20 Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
ISF-08 Suspended Floors (SF) 22 20.01-22 Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
ISF-09 Suspended Floors (SF) 24 22.01-24 Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
ISF-10 Suspended Floors (SF) 26 24.01-26 Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
ISF-11 Suspended Floors (SF) 28 26.01-28 Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
ISF-12 Suspended Floors (SF) 30 28.01-30 Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
ISF-13 Suspended Floors (SF) 32 30.01-32 Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
ISF-14 Suspended Floors (SF) 34 32.01-34 Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
ISF-15 Suspended Floors (SF) 36 34.01-36 Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
ISF-16 Suspended Floors (SF) 38 36.01-38 Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
ISF-17 Suspended Floors (SF) 40 38.01-40 Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
ISF-18 Suspended Floors (SF) 42 40.01-42 Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
ISF-19 Suspended Floors (SF) 44 42.01-44 Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
ISF-20 Suspended Floors (SF) 46 44.01-46 Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
ISF-21 Suspended Floors (SF) 48 46.01-48 Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
ISF-22 Suspended Floors (SF) 50 48.01-50 Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
ISF-23 Suspended Floors (SF) 51 50.01-Above Installation of Suspended Floors (ISF) above 50 m

ITS-01 Tower Structures (TS) 6 0-6 Installation of Tower Structures (ITS) from ground up to 6.00 m
ITS-02 Tower Structures (TS) 8 6.0-8 Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
ITS-03 Tower Structures (TS) 10 8.01-10 Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
ITS-04 Tower Structures (TS) 12 10.01-12 Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
ITS-05 Tower Structures (TS) 14 12.01-14 Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
ITS-06 Tower Structures (TS) 16 14.01-16 Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
ITS-07 Tower Structures (TS) 18 16.01-18 Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
ITS-08 Tower Structures (TS) 20 18.01-20 Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
ITS-09 Tower Structures (TS) 22 20.01-22 Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
ITS-10 Tower Structures (TS) 24 22.01-24 Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
ITS-11 Tower Structures (TS) 26 24.01-26 Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
ITS-12 Tower Structures (TS) 28 26.01-28 Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
ITS-13 Tower Structures (TS) 30 28.01-30 Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
ITS-14 Tower Structures (TS) 32 30.01-32 Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
ITS-15 Tower Structures (TS) 34 32.01-34 Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
ITS-16 Tower Structures (TS) 36 34.01-36 Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
ITS-17 Tower Structures (TS) 38 36.01-38 Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
ITS-18 Tower Structures (TS) 40 38.01-40 Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
ITS-19 Tower Structures (TS) 42 40.01-42 Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
ITS-20 Tower Structures (TS) 44 42.01-44 Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
ITS-21 Tower Structures (TS) 46 44.01-46 Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
ITS-22 Tower Structures (TS) 48 46.01-48 Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
ITS-23 Tower Structures (TS) 50 48.01-50 Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
ITS-24 Tower Structures (TS) 51 50.01-Above Installation of Tower Structures (ITS) above 50 m

IBC-01 Birdcages (IBC) 6 0-6.0 Installation of Birdcages (IBC) from ground up to 6.00 m
IBC-02 Birdcages (IBC) 8 6.01-8 Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
IBC-03 Birdcages (IBC) 10 8.01-10 Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
IBC-04 Birdcages (IBC) 12 10.01-12 Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
IBC-05 Birdcages (IBC) 14 12.01-14 Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
IBC-06 Birdcages (IBC) 16 14.01-16 Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
IBC-07 Birdcages (IBC) 18 16.01-18 Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
IBC-08 Birdcages (IBC) 20 18.01-20 Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
IBC-09 Birdcages (IBC) 22 20.01-22 Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
IBC-10 Birdcages (IBC) 24 22.01-24 Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
IBC-11 Birdcages (IBC) 26 24.01-26 Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
IBC-12 Birdcages (IBC) 28 26.01-28 Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
IBC-13 Birdcages (IBC) 30 28.01-30 Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
IBC-14 Birdcages (IBC) 32 30.01-32 Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
IBC-15 Birdcages (IBC) 34 32.01-34 Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
IBC-16 Birdcages (IBC) 36 34.01-36 Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
IBC-17 Birdcages (IBC) 38 36.01-38 Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
IBC-18 Birdcages (IBC) 40 38.01-40 Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
IBC-19 Birdcages (IBC) 42 40.01-42 Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
IBC-20 Birdcages (IBC) 44 42.01-44 Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
IBC-21 Birdcages (IBC) 46 44.01-46 Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
IBC-22 Birdcages (IBC) 48 46.01-48 Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
IBC-23 Birdcages (IBC) 50 48.01-50 Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
IBC-24 Birdcages (IBC) 51 50.01-Above Installation of Birdcages (IBC) above 50 m

IHBC-01 Hanging Birdcages (IHBC) 2 0-2 Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
IHBC-02 Hanging Birdcages (IHBC) 4 2.01-4 Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
IHBC-03 Hanging Birdcages (IHBC) 6 4.01-6 Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m

IIN-01 Independents (IN) 6 0 - 6.0 Installation of Independents (IIN) from ground up to 6.00 m
IIN-02 Independents (IN) 8 6.01-8 Installation of Independents (IIN) from 6.01 m up to 8.00 m
IIN-03 Independents (IN) 10 8.01-10 Installation of Independents (IIN) from 8.01 m up to 10.00 m
IIN-04 Independents (IN) 12 10.01-12 Installation of Independents (IIN) from 10.01 m up to 12.00 m
IIN-05 Independents (IN) 14 12.01-14 Installation of Independents (IIN) from 12.01 m up to 14.00 m
IIN-06 Independents (IN) 16 14.01-16 Installation of Independents (IIN) from 14.01 m up to 16.00 m
IIN-07 Independents (IN) 18 16.01-18 Installation of Independents (IIN) from 16.01 m up to 18.00 m
IIN-08 Independents (IN) 20 18.01-20 Installation of Independents (IIN) from 18.01 m up to 20.00 m
IIN-09 Independents (IN) 22 20.01-22 Installation of Independents (IIN) from 20.01 m up to 22.00 m
IIN-10 Independents (IN) 24 22.01-24 Installation of Independents (IIN) from 22.01 m up to 24.00 m
IIN-11 Independents (IN) 26 24.01-26 Installation of Independents (IIN) from 24.01 m up to 26.00 m
IIN-12 Independents (IN) 28 26.01-28 Installation of Independents (IIN) from 26.01 m up to 28.00 m
IIN-13 Independents (IN) 30 28.01-30 Installation of Independents (IIN) from 28.01 m up to 30.00 m
IIN-14 Independents (IN) 32 30.01-32 Installation of Independents (IIN) from 30.01 m up to 32.00 m
IIN-15 Independents (IN) 34 32.01-34 Installation of Independents (IIN) from 32.01 m up to 34.00 m
IIN-16 Independents (IN) 36 34.01-36 Installation of Independents (IIN) from 34.01 m up to 36.00 m
IIN-17 Independents (IN) 38 36.01-38 Installation of Independents (IIN) from 36.01 m up to 38.00 m
IIN-18 Independents (IN) 40 38.01-40 Installation of Independents (IIN) from 38.01 m up to 40.00 m
IIN-19 Independents (IN) 42 40.01-42 Installation of Independents (IIN) from 40.01 m up to 42.00 m
IIN-20 Independents (IN) 44 42.01-44 Installation of Independents (IIN) from 42.01 m up to 44.00 m
IIN-21 Independents (IN) 46 44.01-46 Installation of Independents (IIN) from 44.01 m up to 46.00 m
IIN-22 Independents (IN) 48 46.01-48 Installation of Independents (IIN) from 46.01 m up to 48.00 m
IIN-23 Independents (IN) 50 48.01-50 Installation of Independents (IIN) from 48.01 m up to 50.00 m
IIN-24 Independents (IN) 51 50.01-Above Installation of Independents (IIN) above 50 m
 
Sort by date Sort by votes
try this:
Book1
ABCDEF
1Type:Stair Towers (ST)Birdcages (IBC)
2Height52Hanging Birdcages (IHBC)
3Type HeightIndependents (IN)
4ITEM NO. Type Job Height Type DESCRIPTION ITEM NO.Stair Towers (ST)
5Suspended Floors (SF)
6Tower Structures (TS)
7Walkways (WG)
8
9
10
11
12Product NbrProduct NameHeight TypeLow LimitUp LimitDescription
13IST-24Stair Towers (ST)5150.0199999Installation of Stair Towers (IST)
14
15
16
17
18
19IST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m
20IST-02 Stair Towers (ST) 8 6.0-8 Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
21IST-03 Stair Towers (ST) 10 8.01-10 Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
22IST-04 Stair Towers (ST) 12 10.01-12 Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
23IST-05 Stair Towers (ST) 14 12.01-14 Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
24IST-06 Stair Towers (ST) 16 14.01-16 Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
25IST-07 Stair Towers (ST) 18 16.01-18 Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
26IST-08 Stair Towers (ST) 20 18.01-20 Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
27IST-09 Stair Towers (ST) 22 20.01-22 Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
28IST-10 Stair Towers (ST) 24 22.01-24 Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
29IST-11 Stair Towers (ST) 26 24.01-26 Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
30IST-12 Stair Towers (ST) 28 26.01-28 Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
31IST-13 Stair Towers (ST) 30 28.01-30 Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
32IST-14 Stair Towers (ST) 32 30.01-32 Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
33IST-15 Stair Towers (ST) 34 32.01-34 Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
34IST-16 Stair Towers (ST) 36 34.01-36 Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
35IST-17 Stair Towers (ST) 38 36.01-38 Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
36IST-18 Stair Towers (ST) 40 38.01-40 Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
37IST-19 Stair Towers (ST) 42 40.01-42 Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
38IST-20 Stair Towers (ST) 44 42.01-44 Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
39IST-21 Stair Towers (ST) 46 44.01-46 Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
40IST-22 Stair Towers (ST) 48 46.01-48 Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
41IST-23 Stair Towers (ST) 50 48.01-50 Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
42IST-24 Stair Towers (ST) 51 50.01-Above Installation of Stair Towers (IST) above 50 m
43
44IWG-01 Walkways (WG) 8 6.01-8 Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
45IWG-02 Walkways (WG) 10 8.01-10 Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
46IWG-03 Walkways (WG) 12 10.01-12 Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
47IWG-04 Walkways (WG) 14 12.01-14 Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
48IWG-05 Walkways (WG) 16 14.01-16 Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
49IWG-06 Walkways (WG) 18 16.01-18 Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
50IWG-07 Walkways (WG) 20 18.01-20 Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
51IWG-08 Walkways (WG) 22 20.01-22 Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
52IWG-09 Walkways (WG) 24 22.01-24 Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
53IWG-10 Walkways (WG) 26 24.01-26 Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
54IWG-11 Walkways (WG) 28 26.01-28 Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
55IWG-12 Walkways (WG) 30 28.01-30 Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
56IWG-13 Walkways (WG) 32 30.01-32 Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
57IWG-14 Walkways (WG) 34 32.01-34 Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
58IWG-15 Walkways (WG) 36 34.01-36 Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
59IWG-16 Walkways (WG) 38 36.01-38 Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
60IWG-17 Walkways (WG) 40 38.01-40 Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
61IWG-18 Walkways (WG) 42 40.01-42 Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
62IWG-19 Walkways (WG) 44 42.01-44 Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
63IWG-20 Walkways (WG) 46 44.01-46 Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
64IWG-21 Walkways (WG) 48 46.01-48 Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
65IWG-22 Walkways (WG) 50 48.01-50 Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
66IWG-23 Walkways (WG) 51 50.01-Above Installation of Walkways (IWG) , by means of scaffolds built above 50 m
67
68ISF-01 Suspended Floors (SF) 8 6.01-8 Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
69ISF-02 Suspended Floors (SF) 10 8.01-10 Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
70ISF-03 Suspended Floors (SF) 12 10.01-12 Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
71ISF-04 Suspended Floors (SF) 14 12.01-14 Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
72ISF-05 Suspended Floors (SF) 16 14.01-16 Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
73ISF-06 Suspended Floors (SF) 18 16.01-18 Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
74ISF-07 Suspended Floors (SF) 20 18.01-20 Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
75ISF-08 Suspended Floors (SF) 22 20.01-22 Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
76ISF-09 Suspended Floors (SF) 24 22.01-24 Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
77ISF-10 Suspended Floors (SF) 26 24.01-26 Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
78ISF-11 Suspended Floors (SF) 28 26.01-28 Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
79ISF-12 Suspended Floors (SF) 30 28.01-30 Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
80ISF-13 Suspended Floors (SF) 32 30.01-32 Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
81ISF-14 Suspended Floors (SF) 34 32.01-34 Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
82ISF-15 Suspended Floors (SF) 36 34.01-36 Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
83ISF-16 Suspended Floors (SF) 38 36.01-38 Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
84ISF-17 Suspended Floors (SF) 40 38.01-40 Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
85ISF-18 Suspended Floors (SF) 42 40.01-42 Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
86ISF-19 Suspended Floors (SF) 44 42.01-44 Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
87ISF-20 Suspended Floors (SF) 46 44.01-46 Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
88ISF-21 Suspended Floors (SF) 48 46.01-48 Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
89ISF-22 Suspended Floors (SF) 50 48.01-50 Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
90ISF-23 Suspended Floors (SF) 51 50.01-Above Installation of Suspended Floors (ISF) above 50 m
91
92ITS-01 Tower Structures (TS) 6 0-6 Installation of Tower Structures (ITS) from ground up to 6.00 m
93ITS-02 Tower Structures (TS) 8 6.0-8 Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
94ITS-03 Tower Structures (TS) 10 8.01-10 Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
95ITS-04 Tower Structures (TS) 12 10.01-12 Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
96ITS-05 Tower Structures (TS) 14 12.01-14 Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
97ITS-06 Tower Structures (TS) 16 14.01-16 Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
98ITS-07 Tower Structures (TS) 18 16.01-18 Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
99ITS-08 Tower Structures (TS) 20 18.01-20 Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
100ITS-09 Tower Structures (TS) 22 20.01-22 Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
101ITS-10 Tower Structures (TS) 24 22.01-24 Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
102ITS-11 Tower Structures (TS) 26 24.01-26 Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
103ITS-12 Tower Structures (TS) 28 26.01-28 Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
104ITS-13 Tower Structures (TS) 30 28.01-30 Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
105ITS-14 Tower Structures (TS) 32 30.01-32 Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
106ITS-15 Tower Structures (TS) 34 32.01-34 Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
107ITS-16 Tower Structures (TS) 36 34.01-36 Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
108ITS-17 Tower Structures (TS) 38 36.01-38 Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
109ITS-18 Tower Structures (TS) 40 38.01-40 Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
110ITS-19 Tower Structures (TS) 42 40.01-42 Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
111ITS-20 Tower Structures (TS) 44 42.01-44 Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
112ITS-21 Tower Structures (TS) 46 44.01-46 Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
113ITS-22 Tower Structures (TS) 48 46.01-48 Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
114ITS-23 Tower Structures (TS) 50 48.01-50 Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
115ITS-24 Tower Structures (TS) 51 50.01-Above Installation of Tower Structures (ITS) above 50 m
116
117IBC-01 Birdcages (IBC) 6 0-6.0 Installation of Birdcages (IBC) from ground up to 6.00 m
118IBC-02 Birdcages (IBC) 8 6.01-8 Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
119IBC-03 Birdcages (IBC) 10 8.01-10 Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
120IBC-04 Birdcages (IBC) 12 10.01-12 Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
121IBC-05 Birdcages (IBC) 14 12.01-14 Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
122IBC-06 Birdcages (IBC) 16 14.01-16 Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
123IBC-07 Birdcages (IBC) 18 16.01-18 Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
124IBC-08 Birdcages (IBC) 20 18.01-20 Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
125IBC-09 Birdcages (IBC) 22 20.01-22 Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
126IBC-10 Birdcages (IBC) 24 22.01-24 Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
127IBC-11 Birdcages (IBC) 26 24.01-26 Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
128IBC-12 Birdcages (IBC) 28 26.01-28 Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
129IBC-13 Birdcages (IBC) 30 28.01-30 Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
130IBC-14 Birdcages (IBC) 32 30.01-32 Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
131IBC-15 Birdcages (IBC) 34 32.01-34 Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
132IBC-16 Birdcages (IBC) 36 34.01-36 Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
133IBC-17 Birdcages (IBC) 38 36.01-38 Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
134IBC-18 Birdcages (IBC) 40 38.01-40 Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
135IBC-19 Birdcages (IBC) 42 40.01-42 Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
136IBC-20 Birdcages (IBC) 44 42.01-44 Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
137IBC-21 Birdcages (IBC) 46 44.01-46 Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
138IBC-22 Birdcages (IBC) 48 46.01-48 Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
139IBC-23 Birdcages (IBC) 50 48.01-50 Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
140IBC-24 Birdcages (IBC) 51 50.01-Above Installation of Birdcages (IBC) above 50 m
141
142IHBC-01 Hanging Birdcages (IHBC) 2 0-2 Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
143IHBC-02 Hanging Birdcages (IHBC) 4 2.01-4 Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
144IHBC-03 Hanging Birdcages (IHBC) 6 4.01-6 Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
145
146IIN-01 Independents (IN) 6 0 - 6.0 Installation of Independents (IIN) from ground up to 6.00 m
147IIN-02 Independents (IN) 8 6.01-8 Installation of Independents (IIN) from 6.01 m up to 8.00 m
148IIN-03 Independents (IN) 10 8.01-10 Installation of Independents (IIN) from 8.01 m up to 10.00 m
149IIN-04 Independents (IN) 12 10.01-12 Installation of Independents (IIN) from 10.01 m up to 12.00 m
150IIN-05 Independents (IN) 14 12.01-14 Installation of Independents (IIN) from 12.01 m up to 14.00 m
151IIN-06 Independents (IN) 16 14.01-16 Installation of Independents (IIN) from 14.01 m up to 16.00 m
152IIN-07 Independents (IN) 18 16.01-18 Installation of Independents (IIN) from 16.01 m up to 18.00 m
153IIN-08 Independents (IN) 20 18.01-20 Installation of Independents (IIN) from 18.01 m up to 20.00 m
154IIN-09 Independents (IN) 22 20.01-22 Installation of Independents (IIN) from 20.01 m up to 22.00 m
155IIN-10 Independents (IN) 24 22.01-24 Installation of Independents (IIN) from 22.01 m up to 24.00 m
156IIN-11 Independents (IN) 26 24.01-26 Installation of Independents (IIN) from 24.01 m up to 26.00 m
157IIN-12 Independents (IN) 28 26.01-28 Installation of Independents (IIN) from 26.01 m up to 28.00 m
158IIN-13 Independents (IN) 30 28.01-30 Installation of Independents (IIN) from 28.01 m up to 30.00 m
159IIN-14 Independents (IN) 32 30.01-32 Installation of Independents (IIN) from 30.01 m up to 32.00 m
160IIN-15 Independents (IN) 34 32.01-34 Installation of Independents (IIN) from 32.01 m up to 34.00 m
161IIN-16 Independents (IN) 36 34.01-36 Installation of Independents (IIN) from 34.01 m up to 36.00 m
162IIN-17 Independents (IN) 38 36.01-38 Installation of Independents (IIN) from 36.01 m up to 38.00 m
163IIN-18 Independents (IN) 40 38.01-40 Installation of Independents (IIN) from 38.01 m up to 40.00 m
164IIN-19 Independents (IN) 42 40.01-42 Installation of Independents (IIN) from 40.01 m up to 42.00 m
165IIN-20 Independents (IN) 44 42.01-44 Installation of Independents (IIN) from 42.01 m up to 44.00 m
166IIN-21 Independents (IN) 46 44.01-46 Installation of Independents (IIN) from 44.01 m up to 46.00 m
167IIN-22 Independents (IN) 48 46.01-48 Installation of Independents (IIN) from 46.01 m up to 48.00 m
168IIN-23 Independents (IN) 50 48.01-50 Installation of Independents (IIN) from 48.01 m up to 50.00 m
169IIN-24 Independents (IN) 51 50.01-Above Installation of Independents (IIN) above 50 m
Sheet9
Cell Formulas
RangeFormula
D1:D7D1=LET(ProdName,B1, Height,B2, String1,FILTER(A19:A169,A19:A169<>"",""), ProdNbr,TEXTBEFORE(A19:A169," "), Products,TEXTBEFORE(String1,") ")&")", ProductNames,TEXTAFTER(Products," "), SORT(UNIQUE(ProductNames,FALSE,FALSE),1,1))
A12:F13A12=LET(ProdName,$B$1, Height,$B$2, String1,FILTER($A$19:$A$169,$A$19:$A$169<>"",""), ProdNbr,IFERROR(TEXTBEFORE(String1," "),""), Products,TEXTBEFORE(String1,") ")&")", ProductNames,TEXTAFTER(Products," "), Rest1,SUBSTITUTE(String1,Products,""), Htypes,1*TRIM(TEXTBEFORE(Rest1," ",2)), Rest2,SUBSTITUTE(Rest1," "&Htypes&" ",""), LowLimits,1*TEXTBEFORE(Rest2,"-"), UpLimits,IFERROR(1*TEXTAFTER(TEXTBEFORE(Rest2," "),"-"),99999), Desc1,TEXTBEFORE(Rest1,")",)&")", InstLoc,IFERROR(SEARCH("Inst",Desc1),""), LenDesc,LEN(Desc1)+1-InstLoc, Desc2,MID(Desc1,InstLoc,LenDesc), ReptData,HSTACK(ProdNbr,ProductNames,Htypes,LowLimits,UpLimits,Desc2), FilteredData,FILTER(ReptData,(ProductNames=ProdName)*(LowLimits<=Height)*(UpLimits>=Height),""), Header,{"Product Nbr","Product Name","Height Type","Low Limit","Up Limit","Description"}, Final,VSTACK(Header,FilteredData),Final)
Dynamic array formulas.
Cells with Data Validation
CellAllowCriteria
B1List=$D$1:$D$7
 
Upvote 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
This Is the format sir

ITEM NO.TypeJobHeight TypeHeight rangeDESCRIPTION
STStair Towers (ST)
IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02Stair Towers (ST)Install86.01-8Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03Stair Towers (ST)Install108.01-10Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04Stair Towers (ST)Install1210.01-12Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05Stair Towers (ST)Install1412.01-14Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06Stair Towers (ST)Install1614.01-16Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
IST-08Stair Towers (ST)Install200-20Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
IST-09Stair Towers (ST)Install2220.01-22Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
IST-10Stair Towers (ST)Install2422.01-24Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
IST-11Stair Towers (ST)Install2624.01-26Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
IST-12Stair Towers (ST)Install2826.01-28Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
IST-13Stair Towers (ST)Install3028.01-30Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
IST-14Stair Towers (ST)Install3230.01-32Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
IST-15Stair Towers (ST)Install3432.01-34Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
IST-16Stair Towers (ST)Install3634.01-36Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
IST-17Stair Towers (ST)Install3836.01-38Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
IST-18Stair Towers (ST)Install4038.01-40Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
IST-19Stair Towers (ST)Install4240.01-42Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
IST-20Stair Towers (ST)Install4442.01-44Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
IST-21Stair Towers (ST)Install4644.01-46Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
IST-22Stair Towers (ST)Install4846.01-48Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
IST-23Stair Towers (ST)Install5048.01-50Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
IST-24Stair Towers (ST)Install5150.01-AboveInstallation of Stair Towers (IST) above 50 m
WGWalkways (WG)
IWG-01Walkways (WG)Install86.01-8Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
IWG-02Walkways (WG)Install108.01-10Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
IWG-03Walkways (WG)Install1210.01-12Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
IWG-04Walkways (WG)Install1412.01-14Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
IWG-05Walkways (WG)Install1614.01-16Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
IWG-06Walkways (WG)Install1816.01-18Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
IWG-07Walkways (WG)Install2018.01-20Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
IWG-08Walkways (WG)Install2220.01-22Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
IWG-09Walkways (WG)Install2422.01-24Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
IWG-10Walkways (WG)Install2624.01-26Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
IWG-11Walkways (WG)Install2826.01-28Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
IWG-12Walkways (WG)Install3028.01-30Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
IWG-13Walkways (WG)Install3230.01-32Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
IWG-14Walkways (WG)Install3432.01-34Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
IWG-15Walkways (WG)Install3634.01-36Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
IWG-16Walkways (WG)Install3836.01-38Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
IWG-17Walkways (WG)Install4038.01-40Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
IWG-18Walkways (WG)Install4240.01-42Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
IWG-19Walkways (WG)Install4442.01-44Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
IWG-20Walkways (WG)Install4644.01-46Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
IWG-21Walkways (WG)Install4846.01-48Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
IWG-22Walkways (WG)Install5048.01-50Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
IWG-23Walkways (WG)Install5150.01-AboveInstallation of Walkways (IWG) , by means of scaffolds built above 50 m
SFSuspended Floors (SF)
ISF-01Suspended Floors (SF)Install86.01-8Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
ISF-02Suspended Floors (SF)Install108.01-10Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
ISF-03Suspended Floors (SF)Install1210.01-12Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
ISF-04Suspended Floors (SF)Install1412.01-14Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
ISF-05Suspended Floors (SF)Install1614.01-16Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
ISF-06Suspended Floors (SF)Install1816.01-18Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
ISF-07Suspended Floors (SF)Install2018.01-20Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
ISF-08Suspended Floors (SF)Install2220.01-22Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
ISF-09Suspended Floors (SF)Install2422.01-24Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
ISF-10Suspended Floors (SF)Install2624.01-26Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
ISF-11Suspended Floors (SF)Install2826.01-28Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
ISF-12Suspended Floors (SF)Install3028.01-30Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
ISF-13Suspended Floors (SF)Install3230.01-32Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
ISF-14Suspended Floors (SF)Install3432.01-34Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
ISF-15Suspended Floors (SF)Install3634.01-36Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
ISF-16Suspended Floors (SF)Install3836.01-38Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
ISF-17Suspended Floors (SF)Install4038.01-40Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
ISF-18Suspended Floors (SF)Install4240.01-42Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
ISF-19Suspended Floors (SF)Install4442.01-44Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
ISF-20Suspended Floors (SF)Install4644.01-46Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
ISF-21Suspended Floors (SF)Install4846.01-48Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
ISF-22Suspended Floors (SF)Install5048.01-50Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
ISF-23Suspended Floors (SF)Install5150.01-AboveInstallation of Suspended Floors (ISF) above 50 m
TSTower Structures (TS)
ITS-01Tower Structures (TS)Install60-6Installation of Tower Structures (ITS) from ground up to 6.00 m
ITS-02Tower Structures (TS)Install86.01-8Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
ITS-03Tower Structures (TS)Install108.01-10Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
ITS-04Tower Structures (TS)Install1210.01-12Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
ITS-05Tower Structures (TS)Install1412.01-14Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
ITS-06Tower Structures (TS)Install1614.01-16Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
ITS-07Tower Structures (TS)Install1816.01-18Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
ITS-08Tower Structures (TS)Install2018.01-20Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
ITS-09Tower Structures (TS)Install2220.01-22Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
ITS-10Tower Structures (TS)Install2422.01-24Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
ITS-11Tower Structures (TS)Install2624.01-26Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
ITS-12Tower Structures (TS)Install2826.01-28Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
ITS-13Tower Structures (TS)Install3028.01-30Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
ITS-14Tower Structures (TS)Install3230.01-32Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
ITS-15Tower Structures (TS)Install3432.01-34Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
ITS-16Tower Structures (TS)Install3634.01-36Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
ITS-17Tower Structures (TS)Install3836.01-38Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
ITS-18Tower Structures (TS)Install4038.01-40Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
ITS-19Tower Structures (TS)Install4240.01-42Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
ITS-20Tower Structures (TS)Install4442.01-44Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
ITS-21Tower Structures (TS)Install4644.01-46Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
ITS-22Tower Structures (TS)Install4846.01-48Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
ITS-23Tower Structures (TS)Install5048.01-50Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
ITS-24Tower Structures (TS)Install5150.01-AboveInstallation of Tower Structures (ITS) above 50 m
BCBirdcages (IBC)
IBC-01Birdcages (IBC)Install60-6Installation of Birdcages (IBC) from ground up to 6.00 m
IBC-02Birdcages (IBC)Install86.01-8Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
IBC-03Birdcages (IBC)Install108.01-10Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
IBC-04Birdcages (IBC)Install1210.01-12Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
IBC-05Birdcages (IBC)Install1412.01-14Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
IBC-06Birdcages (IBC)Install1614.01-16Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
IBC-07Birdcages (IBC)Install1816.01-18Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
IBC-08Birdcages (IBC)Install2018.01-20Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
IBC-09Birdcages (IBC)Install2220.01-22Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
IBC-10Birdcages (IBC)Install2422.01-24Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
IBC-11Birdcages (IBC)Install2624.01-26Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
IBC-12Birdcages (IBC)Install2826.01-28Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
IBC-13Birdcages (IBC)Install3028.01-30Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
IBC-14Birdcages (IBC)Install3230.01-32Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
IBC-15Birdcages (IBC)Install3432.01-34Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
IBC-16Birdcages (IBC)Install3634.01-36Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
IBC-17Birdcages (IBC)Install3836.01-38Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
IBC-18Birdcages (IBC)Install4038.01-40Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
IBC-19Birdcages (IBC)Install4240.01-42Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
IBC-20Birdcages (IBC)Install4442.01-44Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
IBC-21Birdcages (IBC)Install4644.01-46Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
IBC-22Birdcages (IBC)Install4846.01-48Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
IBC-23Birdcages (IBC)Install5048.01-50Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
IBC-24Birdcages (IBC)Install5150.01-AboveInstallation of Birdcages (IBC) above 50 m
HBHanging Birdcages (IHBC)
IHBC-01Hanging Birdcages (IHBC)Install20-2Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
IHBC-02Hanging Birdcages (IHBC)Install42.01-4Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
IHBC-03Hanging Birdcages (IHBC)Install64.01-6Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
INIndipendents (IN)
IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
IIN-02Independents (IN)Install86.01-8Installation of Independents (IIN) from 6.01 m up to 8.00 m
IIN-03Independents (IN)Install108.01-10Installation of Independents (IIN) from 8.01 m up to 10.00 m
IIN-04Independents (IN)Install1210.01-12Installation of Independents (IIN) from 10.01 m up to 12.00 m
IIN-05Independents (IN)Install1412.01-14Installation of Independents (IIN) from 12.01 m up to 14.00 m
IIN-06Independents (IN)Install1614.01-16Installation of Independents (IIN) from 14.01 m up to 16.00 m
IIN-07Independents (IN)Install1816.01-18Installation of Independents (IIN) from 16.01 m up to 18.00 m
IIN-08Independents (IN)Install2018.01-20Installation of Independents (IIN) from 18.01 m up to 20.00 m
IIN-09Independents (IN)Install2220.01-22Installation of Independents (IIN) from 20.01 m up to 22.00 m
IIN-10Independents (IN)Install2422.01-24Installation of Independents (IIN) from 22.01 m up to 24.00 m
IIN-11Independents (IN)Install2624.01-26Installation of Independents (IIN) from 24.01 m up to 26.00 m
IIN-12Independents (IN)Install2826.01-28Installation of Independents (IIN) from 26.01 m up to 28.00 m
IIN-13Independents (IN)Install3028.01-30Installation of Independents (IIN) from 28.01 m up to 30.00 m
IIN-14Independents (IN)Install3230.01-32Installation of Independents (IIN) from 30.01 m up to 32.00 m
IIN-15Independents (IN)Install3432.01-34Installation of Independents (IIN) from 32.01 m up to 34.00 m
IIN-16Independents (IN)Install3634.01-36Installation of Independents (IIN) from 34.01 m up to 36.00 m
IIN-17Independents (IN)Install3836.01-38Installation of Independents (IIN) from 36.01 m up to 38.00 m
IIN-18Independents (IN)Install4038.01-40Installation of Independents (IIN) from 38.01 m up to 40.00 m
IIN-19Independents (IN)Install4240.01-42Installation of Independents (IIN) from 40.01 m up to 42.00 m
IIN-20Independents (IN)Install4442.01-44Installation of Independents (IIN) from 42.01 m up to 44.00 m
IIN-21Independents (IN)Install4644.01-46Installation of Independents (IIN) from 44.01 m up to 46.00 m
IIN-22Independents (IN)Install4846.01-48Installation of Independents (IIN) from 46.01 m up to 48.00 m
IIN-23Independents (IN)Install5048.01-50Installation of Independents (IIN) from 48.01 m up to 50.00 m
IIN-24Independents (IN)Install5150.01-AboveInstallation of Independents (IIN) above 50 m
HIHanging Indipendents (HI)
IHIN-01Hanging Indipendents (HI)Install20-2Installation of Hanging Independents (IHIN) from structure down to 2.00 m
IHIN-02Hanging Indipendents (HI)Install42.01-4Installation of Hanging Independents (IHIN) from structure down from 2.01 m to 4.00 m
IHIN-03Hanging Indipendents (HI)Install64.01-6Installation of Hanging Independents (IHIN) from structure down from 4.01 m to 6.00 m
HTHanging Tower (HT)
IHTS-01Hanging Tower (HT)Install20-2Installation of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m
IHTS-02Hanging Tower (HT)Install42.01-4Installation of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m
IHTS-03Hanging Tower (HT)Install64.01-6Installation of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m
 
Upvote 0
nazarene said:
Ac

actually sir, i copied this in excel format, but when I paste it in here it becomes like that, no column and appears it come altogether in one line, but in my excel file it is in each column each category, I dont know how to copy my excel file here with the same format.
Click to expand...
nazarene said:
ITEM NO.TypeJobHeight TypeHeight rangeDESCRIPTION
STStair Towers (ST)
IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02Stair Towers (ST)Install86.01-8Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03Stair Towers (ST)Install108.01-10Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04Stair Towers (ST)Install1210.01-12Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05Stair Towers (ST)Install1412.01-14Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06Stair Towers (ST)Install1614.01-16Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
Click to expand...

Well, that changes things alot. I was parsing a single cell into the components.
 
Upvote 0
understand. Not angry at you. I just was doing a lot of parsing.
Try this:

But it looks like you need another differentiator, as the scenario I display results in two records.

Book1
ABCDEFGHIJKLM
1ITEM NO.TypeJobHeight TypeHeight rangeDESCRIPTION
2STStair Towers (ST)
3IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
4IST-02Stair Towers (ST)Install86.01-8Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
5IST-03Stair Towers (ST)Install108.01-10Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
6IST-04Stair Towers (ST)Install1210.01-12Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
7IST-05Stair Towers (ST)Install1412.01-14Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
8IST-06Stair Towers (ST)Install1614.01-16Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
9IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
10
11
12ProductStair Towers (ST)
13Height3
14
15IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
16IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
17
18
Sheet10
Cell Formulas
RangeFormula
A15:F16A15=LET(Product,B12,Height,B13,Raw,A2:F9,Types,B2:B9,FRaw,FILTER(Raw,Types<>"",""),Products,CHOOSECOLS(FRaw,2),LoHeight,1*TEXTBEFORE(CHOOSECOLS(FRaw,5),"-"),UpHeight,1*IFERROR(TEXTAFTER(CHOOSECOLS(FRaw,5),"-"),99999), FILTER(FRaw,(Product=Products)*(LoHeight<=Height)*(UpHeight>=Height),""))
Dynamic array formulas.
 
Upvote 0
Thank you sir, but it came error value. this is my working worksheets this is link on that table I shared to you to you before. the value is where I put the formula and it turn out error value.
on my working sheets item 1 , module RP11s the given height is one, if you refer to our tabulation reference , the result should be 6, since in In Independents (IN)m from 0 to 6 the height type will be 6.
sorry sir I make you tired with my unclear explanation.


This Is my Working sheets

S/NModule #LocationScaffolding DescriptionSize of ScaffoldHeight typeResult
m(W)m(L)m(H)Nos.
1RP11STop Cellar DeckIndependents (IN)55.001.001.00#VALUE!
2RP11SCD-03Cantilever Platforms (ICP)2.003.001.00
RP11SCD-03Birdcages (IBC)4.005.504.001.00
RP11SCD-03Independents (IN)1.001.000.501.00
3RP8SCellar Deck ***. 4Independents (IN)36.001.001.00
4RP8SCellar Deck ***. 1Tower Structures (TS)
5RP8SLeg C2Birdcages (IBC)4.003.806.001.00
6RP11SCellar DeckIndependents (IN)4.004.001.001.00


This is the reference table

ITEM NO.TypeJobHeight TypeHeight rangeDESCRIPTION
STStair Towers (ST)
IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02Stair Towers (ST)Install86.01-8Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03Stair Towers (ST)Install108.01-10Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04Stair Towers (ST)Install1210.01-12Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05Stair Towers (ST)Install1412.01-14Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06Stair Towers (ST)Install1614.01-16Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
IST-08Stair Towers (ST)Install200-20Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
IST-09Stair Towers (ST)Install2220.01-22Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
IST-10Stair Towers (ST)Install2422.01-24Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
IST-11Stair Towers (ST)Install2624.01-26Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
IST-12Stair Towers (ST)Install2826.01-28Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
IST-13Stair Towers (ST)Install3028.01-30Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
IST-14Stair Towers (ST)Install3230.01-32Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
IST-15Stair Towers (ST)Install3432.01-34Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
IST-16Stair Towers (ST)Install3634.01-36Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
IST-17Stair Towers (ST)Install3836.01-38Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
IST-18Stair Towers (ST)Install4038.01-40Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
IST-19Stair Towers (ST)Install4240.01-42Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
IST-20Stair Towers (ST)Install4442.01-44Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
IST-21Stair Towers (ST)Install4644.01-46Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
IST-22Stair Towers (ST)Install4846.01-48Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
IST-23Stair Towers (ST)Install5048.01-50Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
IST-24Stair Towers (ST)Install5150.01-AboveInstallation of Stair Towers (IST) above 50 m
WGWalkways (WG)
IWG-01Walkways (WG)Install86.01-8Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
IWG-02Walkways (WG)Install108.01-10Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
IWG-03Walkways (WG)Install1210.01-12Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
IWG-04Walkways (WG)Install1412.01-14Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
IWG-05Walkways (WG)Install1614.01-16Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
IWG-06Walkways (WG)Install1816.01-18Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
IWG-07Walkways (WG)Install2018.01-20Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
IWG-08Walkways (WG)Install2220.01-22Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
IWG-09Walkways (WG)Install2422.01-24Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
IWG-10Walkways (WG)Install2624.01-26Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
IWG-11Walkways (WG)Install2826.01-28Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
IWG-12Walkways (WG)Install3028.01-30Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
IWG-13Walkways (WG)Install3230.01-32Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
IWG-14Walkways (WG)Install3432.01-34Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
IWG-15Walkways (WG)Install3634.01-36Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
IWG-16Walkways (WG)Install3836.01-38Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
IWG-17Walkways (WG)Install4038.01-40Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
IWG-18Walkways (WG)Install4240.01-42Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
IWG-19Walkways (WG)Install4442.01-44Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
IWG-20Walkways (WG)Install4644.01-46Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
IWG-21Walkways (WG)Install4846.01-48Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
IWG-22Walkways (WG)Install5048.01-50Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
IWG-23Walkways (WG)Install5150.01-AboveInstallation of Walkways (IWG) , by means of scaffolds built above 50 m
SFSuspended Floors (SF)
ISF-01Suspended Floors (SF)Install86.01-8Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
ISF-02Suspended Floors (SF)Install108.01-10Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
ISF-03Suspended Floors (SF)Install1210.01-12Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
ISF-04Suspended Floors (SF)Install1412.01-14Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
ISF-05Suspended Floors (SF)Install1614.01-16Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
ISF-06Suspended Floors (SF)Install1816.01-18Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
ISF-07Suspended Floors (SF)Install2018.01-20Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
ISF-08Suspended Floors (SF)Install2220.01-22Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
ISF-09Suspended Floors (SF)Install2422.01-24Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
ISF-10Suspended Floors (SF)Install2624.01-26Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
ISF-11Suspended Floors (SF)Install2826.01-28Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
ISF-12Suspended Floors (SF)Install3028.01-30Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
ISF-13Suspended Floors (SF)Install3230.01-32Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
ISF-14Suspended Floors (SF)Install3432.01-34Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
ISF-15Suspended Floors (SF)Install3634.01-36Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
ISF-16Suspended Floors (SF)Install3836.01-38Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
ISF-17Suspended Floors (SF)Install4038.01-40Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
ISF-18Suspended Floors (SF)Install4240.01-42Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
ISF-19Suspended Floors (SF)Install4442.01-44Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
ISF-20Suspended Floors (SF)Install4644.01-46Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
ISF-21Suspended Floors (SF)Install4846.01-48Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
ISF-22Suspended Floors (SF)Install5048.01-50Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
ISF-23Suspended Floors (SF)Install5150.01-AboveInstallation of Suspended Floors (ISF) above 50 m
TSTower Structures (TS)
ITS-01Tower Structures (TS)Install60-6Installation of Tower Structures (ITS) from ground up to 6.00 m
ITS-02Tower Structures (TS)Install86.01-8Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
ITS-03Tower Structures (TS)Install108.01-10Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
ITS-04Tower Structures (TS)Install1210.01-12Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
ITS-05Tower Structures (TS)Install1412.01-14Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
ITS-06Tower Structures (TS)Install1614.01-16Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
ITS-07Tower Structures (TS)Install1816.01-18Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
ITS-08Tower Structures (TS)Install2018.01-20Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
ITS-09Tower Structures (TS)Install2220.01-22Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
ITS-10Tower Structures (TS)Install2422.01-24Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
ITS-11Tower Structures (TS)Install2624.01-26Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
ITS-12Tower Structures (TS)Install2826.01-28Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
ITS-13Tower Structures (TS)Install3028.01-30Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
ITS-14Tower Structures (TS)Install3230.01-32Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
ITS-15Tower Structures (TS)Install3432.01-34Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
ITS-16Tower Structures (TS)Install3634.01-36Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
ITS-17Tower Structures (TS)Install3836.01-38Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
ITS-18Tower Structures (TS)Install4038.01-40Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
ITS-19Tower Structures (TS)Install4240.01-42Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
ITS-20Tower Structures (TS)Install4442.01-44Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
ITS-21Tower Structures (TS)Install4644.01-46Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
ITS-22Tower Structures (TS)Install4846.01-48Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
ITS-23Tower Structures (TS)Install5048.01-50Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
ITS-24Tower Structures (TS)Install5150.01-AboveInstallation of Tower Structures (ITS) above 50 m
BCBirdcages (IBC)
IBC-01Birdcages (IBC)Install60-6Installation of Birdcages (IBC) from ground up to 6.00 m
IBC-02Birdcages (IBC)Install86.01-8Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
IBC-03Birdcages (IBC)Install108.01-10Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
IBC-04Birdcages (IBC)Install1210.01-12Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
IBC-05Birdcages (IBC)Install1412.01-14Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
IBC-06Birdcages (IBC)Install1614.01-16Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
IBC-07Birdcages (IBC)Install1816.01-18Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
IBC-08Birdcages (IBC)Install2018.01-20Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
IBC-09Birdcages (IBC)Install2220.01-22Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
IBC-10Birdcages (IBC)Install2422.01-24Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
IBC-11Birdcages (IBC)Install2624.01-26Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
IBC-12Birdcages (IBC)Install2826.01-28Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
IBC-13Birdcages (IBC)Install3028.01-30Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
IBC-14Birdcages (IBC)Install3230.01-32Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
IBC-15Birdcages (IBC)Install3432.01-34Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
IBC-16Birdcages (IBC)Install3634.01-36Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
IBC-17Birdcages (IBC)Install3836.01-38Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
IBC-18Birdcages (IBC)Install4038.01-40Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
IBC-19Birdcages (IBC)Install4240.01-42Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
IBC-20Birdcages (IBC)Install4442.01-44Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
IBC-21Birdcages (IBC)Install4644.01-46Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
IBC-22Birdcages (IBC)Install4846.01-48Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
IBC-23Birdcages (IBC)Install5048.01-50Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
IBC-24Birdcages (IBC)Install5150.01-AboveInstallation of Birdcages (IBC) above 50 m
HBHanging Birdcages (IHBC)
IHBC-01Hanging Birdcages (IHBC)Install20-2Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
IHBC-02Hanging Birdcages (IHBC)Install42.01-4Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
IHBC-03Hanging Birdcages (IHBC)Install64.01-6Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
INIndipendents (IN)
IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
IIN-02Independents (IN)Install86.01-8Installation of Independents (IIN) from 6.01 m up to 8.00 m
IIN-03Independents (IN)Install108.01-10Installation of Independents (IIN) from 8.01 m up to 10.00 m
IIN-04Independents (IN)Install1210.01-12Installation of Independents (IIN) from 10.01 m up to 12.00 m
IIN-05Independents (IN)Install1412.01-14Installation of Independents (IIN) from 12.01 m up to 14.00 m
IIN-06Independents (IN)Install1614.01-16Installation of Independents (IIN) from 14.01 m up to 16.00 m
IIN-07Independents (IN)Install1816.01-18Installation of Independents (IIN) from 16.01 m up to 18.00 m
IIN-08Independents (IN)Install2018.01-20Installation of Independents (IIN) from 18.01 m up to 20.00 m
IIN-09Independents (IN)Install2220.01-22Installation of Independents (IIN) from 20.01 m up to 22.00 m
IIN-10Independents (IN)Install2422.01-24Installation of Independents (IIN) from 22.01 m up to 24.00 m
IIN-11Independents (IN)Install2624.01-26Installation of Independents (IIN) from 24.01 m up to 26.00 m
IIN-12Independents (IN)Install2826.01-28Installation of Independents (IIN) from 26.01 m up to 28.00 m
IIN-13Independents (IN)Install3028.01-30Installation of Independents (IIN) from 28.01 m up to 30.00 m
IIN-14Independents (IN)Install3230.01-32Installation of Independents (IIN) from 30.01 m up to 32.00 m
IIN-15Independents (IN)Install3432.01-34Installation of Independents (IIN) from 32.01 m up to 34.00 m
IIN-16Independents (IN)Install3634.01-36Installation of Independents (IIN) from 34.01 m up to 36.00 m
IIN-17Independents (IN)Install3836.01-38Installation of Independents (IIN) from 36.01 m up to 38.00 m
IIN-18Independents (IN)Install4038.01-40Installation of Independents (IIN) from 38.01 m up to 40.00 m
IIN-19Independents (IN)Install4240.01-42Installation of Independents (IIN) from 40.01 m up to 42.00 m
IIN-20Independents (IN)Install4442.01-44Installation of Independents (IIN) from 42.01 m up to 44.00 m
IIN-21Independents (IN)Install4644.01-46Installation of Independents (IIN) from 44.01 m up to 46.00 m
IIN-22Independents (IN)Install4846.01-48Installation of Independents (IIN) from 46.01 m up to 48.00 m
IIN-23Independents (IN)Install5048.01-50Installation of Independents (IIN) from 48.01 m up to 50.00 m
IIN-24Independents (IN)Install5150.01-AboveInstallation of Independents (IIN) above 50 m
HIHanging Indipendents (HI)
IHIN-01Hanging Indipendents (HI)Install20-2Installation of Hanging Independents (IHIN) from structure down to 2.00 m
IHIN-02Hanging Indipendents (HI)Install42.01-4Installation of Hanging Independents (IHIN) from structure down from 2.01 m to 4.00 m
IHIN-03Hanging Indipendents (HI)Install64.01-6Installation of Hanging Independents (IHIN) from structure down from 4.01 m to 6.00 m
HTHanging Tower (HT)
IHTS-01Hanging Tower (HT)Install20-2Installation of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m
IHTS-02Hanging Tower (HT)Install42.01-4Installation of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m
IHTS-03Hanging Tower (HT)Install64.01-6Installation of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m
 
Upvote 0
What is your formula in the cellwith #VALUE error? Paste it here please.
I do not see anything like a "Product Name (PN)" or Height that you are trying to look up.

Please give examples of all the CRITERIA, Please say where they are Please give example of expectation.
 
Upvote 0
Okay, Please copy this into a brand new workbook before you do anything else.
It works for me, it should work for you.

Also, you have a new TYPE in the workbook.

The Orange Highlighted records seem very odd to me. Please confirm youwant it this way.

Get it working correctly in a fresh workbook before you start updating your data.

Book1
ABCDEFGHIJKLMNO
1S/NModule #LocationScaffolding DescriptionSize of ScaffoldHeight typeResult
2m(W)m(L)m(H)Nos.
31RP11STop Cellar DeckIndependents (IN)5511IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
42RP11SCD-03Cantilever Platforms (ICP)231Not Found
5RP11SCD-03Birdcages (IBC)45.541IBC-01Birdcages (IBC)Install60-6Installation of Birdcages (IBC) from ground up to 6.00 m
6RP11SCD-03Independents (IN)110.51IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
73RP8SCellar Deck ***. 4Independents (IN)3611IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
84RP8SCellar Deck ***. 1Tower Structures (TS)ITS-01Tower Structures (TS)Install60-6Installation of Tower Structures (ITS) from ground up to 6.00 m
95RP8SLeg C2Birdcages (IBC)43.861IBC-01Birdcages (IBC)Install60-6Installation of Birdcages (IBC) from ground up to 6.00 m
106RP11SCellar DeckIndependents (IN)4411IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
11
12^^^^ IS THIS THE TYPE???? ^^^^^^^^IS THIS THE HEIGHT???^^
13
14Independents (IN)Match Found
15Cantilever Platforms (ICP) IS NOT IN THE LIST OF TYPES!!!
16Birdcages (IBC)Match Found
17Independents (IN)Match Found
18Independents (IN)Match Found
19Tower Structures (TS)Match Found
20Birdcages (IBC)Match Found
21Independents (IN)Match Found
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36This is the reference table
37
38ITEM NO.TypeJobHeight TypeHeight rangeDESCRIPTION
39STStair Towers (ST)
40IST-01Stair Towers (ST)Install60-6Installation of Stair Towers (IST) from ground up to 6.00 m
41IST-02Stair Towers (ST)Install86.01-8Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
42IST-03Stair Towers (ST)Install108.01-10Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
43IST-04Stair Towers (ST)Install1210.01-12Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
44IST-05Stair Towers (ST)Install1412.01-14Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
45IST-06Stair Towers (ST)Install1614.01-16Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
46IST-07Stair Towers (ST)Install180-18Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
47IST-08Stair Towers (ST)Install200-20Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
48IST-09Stair Towers (ST)Install2220.01-22Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
49IST-10Stair Towers (ST)Install2422.01-24Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
50IST-11Stair Towers (ST)Install2624.01-26Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
51IST-12Stair Towers (ST)Install2826.01-28Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
52IST-13Stair Towers (ST)Install3028.01-30Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
53IST-14Stair Towers (ST)Install3230.01-32Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
54IST-15Stair Towers (ST)Install3432.01-34Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
55IST-16Stair Towers (ST)Install3634.01-36Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
56IST-17Stair Towers (ST)Install3836.01-38Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
57IST-18Stair Towers (ST)Install4038.01-40Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
58IST-19Stair Towers (ST)Install4240.01-42Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
59IST-20Stair Towers (ST)Install4442.01-44Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
60IST-21Stair Towers (ST)Install4644.01-46Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
61IST-22Stair Towers (ST)Install4846.01-48Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
62IST-23Stair Towers (ST)Install5048.01-50Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
63IST-24Stair Towers (ST)Install5150.01-AboveInstallation of Stair Towers (IST) above 50 m
64WGWalkways (WG)
65IWG-01Walkways (WG)Install86.01-8Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
66IWG-02Walkways (WG)Install108.01-10Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
67IWG-03Walkways (WG)Install1210.01-12Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
68IWG-04Walkways (WG)Install1412.01-14Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
69IWG-05Walkways (WG)Install1614.01-16Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
70IWG-06Walkways (WG)Install1816.01-18Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
71IWG-07Walkways (WG)Install2018.01-20Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
72IWG-08Walkways (WG)Install2220.01-22Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
73IWG-09Walkways (WG)Install2422.01-24Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
74IWG-10Walkways (WG)Install2624.01-26Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
75IWG-11Walkways (WG)Install2826.01-28Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
76IWG-12Walkways (WG)Install3028.01-30Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
77IWG-13Walkways (WG)Install3230.01-32Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
78IWG-14Walkways (WG)Install3432.01-34Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
79IWG-15Walkways (WG)Install3634.01-36Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
80IWG-16Walkways (WG)Install3836.01-38Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
81IWG-17Walkways (WG)Install4038.01-40Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
82IWG-18Walkways (WG)Install4240.01-42Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
83IWG-19Walkways (WG)Install4442.01-44Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
84IWG-20Walkways (WG)Install4644.01-46Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
85IWG-21Walkways (WG)Install4846.01-48Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
86IWG-22Walkways (WG)Install5048.01-50Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
87IWG-23Walkways (WG)Install5150.01-AboveInstallation of Walkways (IWG) , by means of scaffolds built above 50 m
88SFSuspended Floors (SF)
89ISF-01Suspended Floors (SF)Install86.01-8Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
90ISF-02Suspended Floors (SF)Install108.01-10Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
91ISF-03Suspended Floors (SF)Install1210.01-12Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
92ISF-04Suspended Floors (SF)Install1412.01-14Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
93ISF-05Suspended Floors (SF)Install1614.01-16Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
94ISF-06Suspended Floors (SF)Install1816.01-18Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
95ISF-07Suspended Floors (SF)Install2018.01-20Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
96ISF-08Suspended Floors (SF)Install2220.01-22Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
97ISF-09Suspended Floors (SF)Install2422.01-24Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
98ISF-10Suspended Floors (SF)Install2624.01-26Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
99ISF-11Suspended Floors (SF)Install2826.01-28Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
100ISF-12Suspended Floors (SF)Install3028.01-30Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
101ISF-13Suspended Floors (SF)Install3230.01-32Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
102ISF-14Suspended Floors (SF)Install3432.01-34Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
103ISF-15Suspended Floors (SF)Install3634.01-36Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
104ISF-16Suspended Floors (SF)Install3836.01-38Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
105ISF-17Suspended Floors (SF)Install4038.01-40Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
106ISF-18Suspended Floors (SF)Install4240.01-42Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
107ISF-19Suspended Floors (SF)Install4442.01-44Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
108ISF-20Suspended Floors (SF)Install4644.01-46Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
109ISF-21Suspended Floors (SF)Install4846.01-48Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
110ISF-22Suspended Floors (SF)Install5048.01-50Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
111ISF-23Suspended Floors (SF)Install5150.01-AboveInstallation of Suspended Floors (ISF) above 50 m
112TSTower Structures (TS)
113ITS-01Tower Structures (TS)Install60-6Installation of Tower Structures (ITS) from ground up to 6.00 m
114ITS-02Tower Structures (TS)Install86.01-8Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
115ITS-03Tower Structures (TS)Install108.01-10Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
116ITS-04Tower Structures (TS)Install1210.01-12Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
117ITS-05Tower Structures (TS)Install1412.01-14Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
118ITS-06Tower Structures (TS)Install1614.01-16Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
119ITS-07Tower Structures (TS)Install1816.01-18Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
120ITS-08Tower Structures (TS)Install2018.01-20Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
121ITS-09Tower Structures (TS)Install2220.01-22Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
122ITS-10Tower Structures (TS)Install2422.01-24Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
123ITS-11Tower Structures (TS)Install2624.01-26Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
124ITS-12Tower Structures (TS)Install2826.01-28Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
125ITS-13Tower Structures (TS)Install3028.01-30Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
126ITS-14Tower Structures (TS)Install3230.01-32Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
127ITS-15Tower Structures (TS)Install3432.01-34Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
128ITS-16Tower Structures (TS)Install3634.01-36Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
129ITS-17Tower Structures (TS)Install3836.01-38Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
130ITS-18Tower Structures (TS)Install4038.01-40Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
131ITS-19Tower Structures (TS)Install4240.01-42Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
132ITS-20Tower Structures (TS)Install4442.01-44Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
133ITS-21Tower Structures (TS)Install4644.01-46Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
134ITS-22Tower Structures (TS)Install4846.01-48Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
135ITS-23Tower Structures (TS)Install5048.01-50Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
136ITS-24Tower Structures (TS)Install5150.01-AboveInstallation of Tower Structures (ITS) above 50 m
137BCBirdcages (IBC)
138IBC-01Birdcages (IBC)Install60-6Installation of Birdcages (IBC) from ground up to 6.00 m
139IBC-02Birdcages (IBC)Install86.01-8Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
140IBC-03Birdcages (IBC)Install108.01-10Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
141IBC-04Birdcages (IBC)Install1210.01-12Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
142IBC-05Birdcages (IBC)Install1412.01-14Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
143IBC-06Birdcages (IBC)Install1614.01-16Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
144IBC-07Birdcages (IBC)Install1816.01-18Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
145IBC-08Birdcages (IBC)Install2018.01-20Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
146IBC-09Birdcages (IBC)Install2220.01-22Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
147IBC-10Birdcages (IBC)Install2422.01-24Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
148IBC-11Birdcages (IBC)Install2624.01-26Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
149IBC-12Birdcages (IBC)Install2826.01-28Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
150IBC-13Birdcages (IBC)Install3028.01-30Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
151IBC-14Birdcages (IBC)Install3230.01-32Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
152IBC-15Birdcages (IBC)Install3432.01-34Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
153IBC-16Birdcages (IBC)Install3634.01-36Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
154IBC-17Birdcages (IBC)Install3836.01-38Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
155IBC-18Birdcages (IBC)Install4038.01-40Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
156IBC-19Birdcages (IBC)Install4240.01-42Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
157IBC-20Birdcages (IBC)Install4442.01-44Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
158IBC-21Birdcages (IBC)Install4644.01-46Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
159IBC-22Birdcages (IBC)Install4846.01-48Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
160IBC-23Birdcages (IBC)Install5048.01-50Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
161IBC-24Birdcages (IBC)Install5150.01-AboveInstallation of Birdcages (IBC) above 50 m
162HBHanging Birdcages (IHBC)
163IHBC-01Hanging Birdcages (IHBC)Install20-2Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
164IHBC-02Hanging Birdcages (IHBC)Install42.01-4Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
165IHBC-03Hanging Birdcages (IHBC)Install64.01-6Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
166INIndipendents (IN)
167IIN-01Independents (IN)Install60-6Installation of Independents (IIN) from ground up to 6.00 m
168IIN-02Independents (IN)Install86.01-8Installation of Independents (IIN) from 6.01 m up to 8.00 m
169IIN-03Independents (IN)Install108.01-10Installation of Independents (IIN) from 8.01 m up to 10.00 m
170IIN-04Independents (IN)Install1210.01-12Installation of Independents (IIN) from 10.01 m up to 12.00 m
171IIN-05Independents (IN)Install1412.01-14Installation of Independents (IIN) from 12.01 m up to 14.00 m
172IIN-06Independents (IN)Install1614.01-16Installation of Independents (IIN) from 14.01 m up to 16.00 m
173IIN-07Independents (IN)Install1816.01-18Installation of Independents (IIN) from 16.01 m up to 18.00 m
174IIN-08Independents (IN)Install2018.01-20Installation of Independents (IIN) from 18.01 m up to 20.00 m
175IIN-09Independents (IN)Install2220.01-22Installation of Independents (IIN) from 20.01 m up to 22.00 m
176IIN-10Independents (IN)Install2422.01-24Installation of Independents (IIN) from 22.01 m up to 24.00 m
177IIN-11Independents (IN)Install2624.01-26Installation of Independents (IIN) from 24.01 m up to 26.00 m
178IIN-12Independents (IN)Install2826.01-28Installation of Independents (IIN) from 26.01 m up to 28.00 m
179IIN-13Independents (IN)Install3028.01-30Installation of Independents (IIN) from 28.01 m up to 30.00 m
180IIN-14Independents (IN)Install3230.01-32Installation of Independents (IIN) from 30.01 m up to 32.00 m
181IIN-15Independents (IN)Install3432.01-34Installation of Independents (IIN) from 32.01 m up to 34.00 m
182IIN-16Independents (IN)Install3634.01-36Installation of Independents (IIN) from 34.01 m up to 36.00 m
183IIN-17Independents (IN)Install3836.01-38Installation of Independents (IIN) from 36.01 m up to 38.00 m
184IIN-18Independents (IN)Install4038.01-40Installation of Independents (IIN) from 38.01 m up to 40.00 m
185IIN-19Independents (IN)Install4240.01-42Installation of Independents (IIN) from 40.01 m up to 42.00 m
186IIN-20Independents (IN)Install4442.01-44Installation of Independents (IIN) from 42.01 m up to 44.00 m
187IIN-21Independents (IN)Install4644.01-46Installation of Independents (IIN) from 44.01 m up to 46.00 m
188IIN-22Independents (IN)Install4846.01-48Installation of Independents (IIN) from 46.01 m up to 48.00 m
189IIN-23Independents (IN)Install5048.01-50Installation of Independents (IIN) from 48.01 m up to 50.00 m
190IIN-24Independents (IN)Install5150.01-AboveInstallation of Independents (IIN) above 50 m
191HIHanging Indipendents (HI)
192IHIN-01Hanging Indipendents (HI)Install20-2Installation of Hanging Independents (IHIN) from structure down to 2.00 m
193IHIN-02Hanging Indipendents (HI)Install42.01-4Installation of Hanging Independents (IHIN) from structure down from 2.01 m to 4.00 m
194IHIN-03Hanging Indipendents (HI)Install64.01-6Installation of Hanging Independents (IHIN) from structure down from 4.01 m to 6.00 m
195HTHanging Tower (HT)
196IHTS-01Hanging Tower (HT)Install20-2Installation of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m
197IHTS-02Hanging Tower (HT)Install42.01-4Installation of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m
198IHTS-03Hanging Tower (HT)Install64.01-6Installation of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m
Sheet1
Cell Formulas
RangeFormula
J3:O3,J5:O10,J4J3=LET( Product,$D3, Height,$G3, Raw,$A$39:$F$198, Prod,CHOOSECOLS(Raw,2), FRaw,FILTER(Raw,Prod<>"",""), Types,CHOOSECOLS(FRaw,2), LoHeight,1*TEXTBEFORE(CHOOSECOLS(FRaw,5),"-"), UpHeight,IFERROR(1*TEXTAFTER(CHOOSECOLS(FRaw,5),"-"),99999), Final,FILTER(FRaw,(Product=Types)*(LoHeight<=Height)*(UpHeight>=Height),"Not Found"), Final)
D14:D21D14=D3 & IF(ISNA(MATCH(D3,$B$38:$B$198,0))," IS NOT IN THE LIST OF TYPES!!!","Match Found")
Dynamic array formulas.
 
Upvote 0
yes sir,
What is your formula in the cell with #VALUE error? this is the formula i created, but since there is many module type , need to creaste the criteria for each module so we can get the exact type height of a given value (height).

IF(AND(VALUE(I9)>0,VALUE(I9)<=6),"6",IF(AND(VALUE(I9)>=6.01,VALUE(I9)<=8),8,IF(AND(VALUE(I9)>=8.01,VALUE(I9)<=10),10,IF(AND(VALUE(I9)>=10.01,VALUE(I9)<=12),12,IF(AND(VALUE(I9)>=12.01,VALUE(I9)<=14),14,IF(AND(VALUE(I9)>=14.01,VALUE(I9)<=16),16,IF(AND(VALUE(I9)>=16.01,VALUE(I9)<=18),18,IF(AND(VALUE(I9)>=18.01,VALUE(I9)<=20),20,IF(AND(VALUE(I9)>=20.01,VALUE(I9)<=22),22,IF(AND(VALUE(I9)>=22.01,VALUE(I9)<=24),24,IF(AND(VALUE(I9)>=24.01,VALUE(I9)<=26),26,IF(AND(VALUE(I9)>=26.01,VALUE(I9)<=28),28,IF(AND(VALUE(I9)>=28.01,VALUE(I9)<=30),30,IF(AND(VALUE(I9)>=30.01,VALUE(I9)<=32),32,IF(AND(VALUE(I9)>=32.01,VALUE(I9)<=34),34,IF(AND(VALUE(I9)>=36.01,VALUE(I9)<=36),36,IF(AND(VALUE(I9)>=36.01,VALUE(I9)<=38),38,IF(AND(VALUE(I9)>=38.01,VALUE(I9)<=40),40,IF(AND(VALUE(I9)>=40.01,VALUE(I9)<=42),42,IF(AND(VALUE(I9)>=42.01,VALUE(I9)<=44),44,IF(AND(VALUE(I9)>=44.01,VALUE(I9)<=46),46,IF(AND(VALUE(I9)>=46.01,VALUE(I9)<=48),48,IF(AND(VALUE(I9)>=48.01,VALUE(I9)<=50),50,IF(AND(VALUE(I9)>=50.01,VALUE(I9)<=51),51,"")))))))))))))))))))))))))))


The criteria is like this,
In the "Type" column there is different type of module like Stair Tower (ST), Walkways (WG) etc.,
In the Height range there if Given Height range example 6.01-8, 8.01-10 etc.
In the height type there is corresponding height type for each category example the height is 0m -6 m, this range belongs to Height type 6
so on the reference table below, I want to create a formula that the result will be based on height type of each category.

for example as per below table1.1 (working sheets).
The scaffolding description is "Independents IN"
The Height is 1 m, so if we refer from my reference table 1.2 (reference) criteria below, the result height type will be 6.
since in my criteria the height from 0m to 6m will be 6m.

Table 1.1 (working sheets)
1. Scafolding Description2. Height Meter3. Height type -Result ( the formula will be paste on this column
Independents (IN)1.006


Table 1.2 (reference)
ITEM NO.TypeJobHeight RangeHeight TypeDESCRIPTION
STStair Towers (ST)
IST-01Stair Towers (ST)Install0-66Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02Stair Towers (ST)Install6.01-88Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03Stair Towers (ST)Install8.01-1010Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04Stair Towers (ST)Install10.01-1212Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05Stair Towers (ST)Install12.01-1414Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06Stair Towers (ST)Install14.01-1616Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07Stair Towers (ST)Install16.01-1818Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
IST-08Stair Towers (ST)Install18.01-2020Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
IST-09Stair Towers (ST)Install20.01-2222Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
IST-10Stair Towers (ST)Install22.01-2424Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
IST-11Stair Towers (ST)Install24.01-2626Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
IST-12Stair Towers (ST)Install26.01-2828Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
IST-13Stair Towers (ST)Install28.01-3030Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
IST-14Stair Towers (ST)Install30.01-3232Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
IST-15Stair Towers (ST)Install32.01-3434Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
IST-16Stair Towers (ST)Install34.01-3636Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
IST-17Stair Towers (ST)Install36.01-3838Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
IST-18Stair Towers (ST)Install38.01-4040Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
IST-19Stair Towers (ST)Install40.01-4242Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
IST-20Stair Towers (ST)Install42.01-4444Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
IST-21Stair Towers (ST)Install44.01-4646Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
IST-22Stair Towers (ST)Install46.01-4848Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
IST-23Stair Towers (ST)Install48.01-5050Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
IST-23Stair Towers (ST)Install50.01- Above51Installation of Stair Towers (IST) above 50 m
WGWalkways (WG)
IWG-01Walkways (WG)Install6.01-88Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
IWG-02Walkways (WG)Install8.01-1010Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
IWG-03Walkways (WG)Install10.01-1212Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
IWG-04Walkways (WG)Install12.01-1414Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
IWG-05Walkways (WG)Install14.01-1616Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
IWG-06Walkways (WG)Install16.01-1818Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
IWG-07Walkways (WG)Install18.01-2020Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
IWG-08Walkways (WG)Install20.01-2222Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
IWG-09Walkways (WG)Install22.01-2424Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
IWG-10Walkways (WG)Install24.01-2626Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
IWG-11Walkways (WG)Install26.01-2828Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
IWG-12Walkways (WG)Install28.01-3030Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
IWG-13Walkways (WG)Install30.01-3232Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
IWG-14Walkways (WG)Install32.01-3434Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
IWG-15Walkways (WG)Install34.01-3636Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
IWG-16Walkways (WG)Install36.01-3838Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
IWG-17Walkways (WG)Install38.01-4040Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
IWG-18Walkways (WG)Install40.01-4242Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
IWG-19Walkways (WG)Install42.01-4444Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
IWG-20Walkways (WG)Install44.01-4646Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
IWG-21Walkways (WG)Install46.01-4848Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
IWG-22Walkways (WG)Install48.01-5050Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
IWG-23Walkways (WG)Install50.01-Above51Installation of Walkways (IWG) , by means of scaffolds built above 50 m
SFSuspended Floors (SF)
ISF-01Suspended Floors (SF)Install6.01-88Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
ISF-02Suspended Floors (SF)Install8.01-1010Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
ISF-03Suspended Floors (SF)Install10.01-1212Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
ISF-04Suspended Floors (SF)Install12.01-1414Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
ISF-05Suspended Floors (SF)Install14.01-1616Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
ISF-06Suspended Floors (SF)Install16.01-1818Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
ISF-07Suspended Floors (SF)Install18.01-2020Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
ISF-08Suspended Floors (SF)Install20.01-2222Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
ISF-09Suspended Floors (SF)Install22.01-2424Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
ISF-10Suspended Floors (SF)Install24.01-2626Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
ISF-11Suspended Floors (SF)Install26.01-2828Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
ISF-12Suspended Floors (SF)Install28.01-3030Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
ISF-13Suspended Floors (SF)Install30.01-3232Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
ISF-14Suspended Floors (SF)Install32.01-3434Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
ISF-15Suspended Floors (SF)Install34.01-3636Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
ISF-16Suspended Floors (SF)Install36.01-3838Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
ISF-17Suspended Floors (SF)Install38.01-4040Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
ISF-18Suspended Floors (SF)Install40.01-4242Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
ISF-19Suspended Floors (SF)Install42.01-4444Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
ISF-20Suspended Floors (SF)Install44.01-4646Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
ISF-21Suspended Floors (SF)Install46.01-4848Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
ISF-22Suspended Floors (SF)Install48.01-5050Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
ISF-23Suspended Floors (SF)Install50.01-Above51Installation of Suspended Floors (ISF) above 50 m
TSTower Structures (TS)
ITS-01Tower Structures (TS)Install0-66Installation of Tower Structures (ITS) from ground up to 6.00 m
ITS-02Tower Structures (TS)Install6.01-88Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
ITS-03Tower Structures (TS)Install8.01-1010Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
ITS-04Tower Structures (TS)Install10.01-1212Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
ITS-05Tower Structures (TS)Install12.01-1414Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
ITS-06Tower Structures (TS)Install14.01-1616Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
ITS-07Tower Structures (TS)Install16.01-1818Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
ITS-08Tower Structures (TS)Install18.01-2020Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
ITS-09Tower Structures (TS)Install20.01-2222Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
ITS-10Tower Structures (TS)Install22.01-2424Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
ITS-11Tower Structures (TS)Install24.01-2626Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
ITS-12Tower Structures (TS)Install26.01-2828Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
ITS-13Tower Structures (TS)Install28.01-3030Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
ITS-14Tower Structures (TS)Install30.01-3232Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
ITS-15Tower Structures (TS)Install32.01-3434Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
ITS-16Tower Structures (TS)Install34.01-3636Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
ITS-17Tower Structures (TS)Install36.01-3838Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
ITS-18Tower Structures (TS)Install38.01-4040Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
ITS-19Tower Structures (TS)Install40.01-4242Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
ITS-20Tower Structures (TS)Install42.01-4444Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
ITS-21Tower Structures (TS)Install44.01-4646Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
ITS-22Tower Structures (TS)Install46.01-4848Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
ITS-23Tower Structures (TS)Install48.01-5050Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
ITS-24Tower Structures (TS)Install50.01-Above51Installation of Tower Structures (ITS) above 50 m
BCBirdcages (IBC)
IBC-01Birdcages (IBC)Install0-66Installation of Birdcages (IBC) from ground up to 6.00 m
IBC-02Birdcages (IBC)Install6.01-88Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
IBC-03Birdcages (IBC)Install8.01-1010Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
IBC-04Birdcages (IBC)Install10.01-1212Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
IBC-05Birdcages (IBC)Install12.01-1414Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
IBC-06Birdcages (IBC)Install14.01-1616Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
IBC-07Birdcages (IBC)Install16.01-1818Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
IBC-08Birdcages (IBC)Install18.01-2020Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
IBC-09Birdcages (IBC)Install20.01-2222Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
IBC-10Birdcages (IBC)Install22.01-2424Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
IBC-11Birdcages (IBC)Install24.01-2626Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
IBC-12Birdcages (IBC)Install26.01-2828Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
IBC-13Birdcages (IBC)Install28.01-3030Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
IBC-14Birdcages (IBC)Install30.01-3232Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
IBC-15Birdcages (IBC)Install32.01-3434Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
IBC-16Birdcages (IBC)Install34.01-3636Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
IBC-17Birdcages (IBC)Install36.01-3838Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
IBC-18Birdcages (IBC)Install38.01-4040Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
IBC-19Birdcages (IBC)Install40.01-4242Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
IBC-20Birdcages (IBC)Install42.01-4444Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
IBC-21Birdcages (IBC)Install44.01-4646Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
IBC-22Birdcages (IBC)Install46.01-4848Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
IBC-23Birdcages (IBC)Install48.01-5050Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
IBC-24Birdcages (IBC)Install50.01-Above51Installation of Birdcages (IBC) above 50 m
HBHanging Birdcages (IHBC)
IHBC-01Hanging Birdcages (IHBC)Install0-22Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
IHBC-02Hanging Birdcages (IHBC)Install2.01-44Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
IHBC-03Hanging Birdcages (IHBC)Install4.01-66Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
INIndipendents (IN)
IIN-01Independents (IN)Install0-66Installation of Independents (IIN) from ground up to 6.00 m
IIN-02Independents (IN)Install6.01-88Installation of Independents (IIN) from 6.01 m up to 8.00 m
IIN-03Independents (IN)Install8.01-1010Installation of Independents (IIN) from 8.01 m up to 10.00 m
IIN-04Independents (IN)Install10.01-1212Installation of Independents (IIN) from 10.01 m up to 12.00 m
IIN-05Independents (IN)Install12.01-1414Installation of Independents (IIN) from 12.01 m up to 14.00 m
IIN-06Independents (IN)Install14.01-1616Installation of Independents (IIN) from 14.01 m up to 16.00 m
IIN-07Independents (IN)Install16.01-1818Installation of Independents (IIN) from 16.01 m up to 18.00 m
IIN-08Independents (IN)Install18.01-2020Installation of Independents (IIN) from 18.01 m up to 20.00 m
IIN-09Independents (IN)Install20.01-2222Installation of Independents (IIN) from 20.01 m up to 22.00 m
IIN-10Independents (IN)Install22.01-2424Installation of Independents (IIN) from 22.01 m up to 24.00 m
IIN-11Independents (IN)Install24.01-2626Installation of Independents (IIN) from 24.01 m up to 26.00 m
IIN-12Independents (IN)Install26.01-2828Installation of Independents (IIN) from 26.01 m up to 28.00 m
IIN-13Independents (IN)Install28.01-3030Installation of Independents (IIN) from 28.01 m up to 30.00 m
IIN-14Independents (IN)Install30.01-3232Installation of Independents (IIN) from 30.01 m up to 32.00 m
IIN-15Independents (IN)Install32.01-3434Installation of Independents (IIN) from 32.01 m up to 34.00 m
IIN-16Independents (IN)Install34.01-3636Installation of Independents (IIN) from 34.01 m up to 36.00 m
IIN-17Independents (IN)Install36.01-3838Installation of Independents (IIN) from 36.01 m up to 38.00 m
IIN-18Independents (IN)Install38.01-4040Installation of Independents (IIN) from 38.01 m up to 40.00 m
IIN-19Independents (IN)Install40.01-4242Installation of Independents (IIN) from 40.01 m up to 42.00 m
IIN-20Independents (IN)Install42.01-4444Installation of Independents (IIN) from 42.01 m up to 44.00 m
IIN-21Independents (IN)Install44.01-4646Installation of Independents (IIN) from 44.01 m up to 46.00 m
IIN-22Independents (IN)Install46.01-4848Installation of Independents (IIN) from 46.01 m up to 48.00 m
IIN-23Independents (IN)Install48.01-5050Installation of Independents (IIN) from 48.01 m up to 50.00 m
IIN-24Independents (IN)Install50.01-Above51Installation of Independents (IIN) above 50 m
HIHanging Indipendents (HI)
IHIN-01Hanging Indipendents (HI)Install0-22Installation of Hanging Independents (IHIN) from structure down to 2.00 m
IHIN-02Hanging Indipendents (HI)Install2.01-44Installation of Hanging Independents (IHIN) from structure down from 2.01 m to 4.00 m
IHIN-03Hanging Indipendents (HI)Install4.01-66Installation of Hanging Independents (IHIN) from structure down from 4.01 m to 6.00 m
HTHanging Tower (HT)
IHTS-01Hanging Tower (HT)Install0-22Installation of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m
IHTS-02Hanging Tower (HT)Install2.01-44Installation of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m
IHTS-03Hanging Tower (HT)Install4.01-66Installation of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m
 
Upvote 0
Did you paste my last post in a brand new workbook? Did it work?
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,215,073
Messages
6,122,970
Members
449,095
Latest member
Mr Hughes

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