muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i have problem how to importrange with criteria name of City as parameter. i want 1 formula can able cover all range/rows
this my link
https://docs.google.com/spreadsheets...it?usp=sharing
this step:
1. my formula in sheet REKAP ALL IKU cell B5-B10.
2. sheet SBSK (1/13) as sources with data from B7 till H12
here this formula for work in 1 city...i want the formula work all city without edit 1 by 1
=ArrayFormula(({IMPORTRANGE("demo version";"SBSK (1/13)!b$7")\QUERY(IMPORTRANGE("demo version";"SBSK (1/13)!B$7:h$7");"Select Col2, Col3, Col4,Col5, Col6 Where Col2 ='KPKNL PADANG'";1)}))
how to fix this problem, 1 fill data based on name city with 1 formula at once
anyone help me, greatly appreciated...
cross posting
susan
i have problem how to importrange with criteria name of City as parameter. i want 1 formula can able cover all range/rows
this my link
https://docs.google.com/spreadsheets...it?usp=sharing
this step:
1. my formula in sheet REKAP ALL IKU cell B5-B10.
2. sheet SBSK (1/13) as sources with data from B7 till H12
here this formula for work in 1 city...i want the formula work all city without edit 1 by 1
=ArrayFormula(({IMPORTRANGE("demo version";"SBSK (1/13)!b$7")\QUERY(IMPORTRANGE("demo version";"SBSK (1/13)!B$7:h$7");"Select Col2, Col3, Col4,Col5, Col6 Where Col2 ='KPKNL PADANG'";1)}))
how to fix this problem, 1 fill data based on name city with 1 formula at once
anyone help me, greatly appreciated...
cross posting
Google Sheet : Import Range Based on Certainty Column With Single Formula
hi all... i have problem how to importrange with criteria name of City as parameter. i want 1 formula can able cover all range/rows this my link https://docs.google.com/spreadsheets/d/1NrhJ863JaExJge4ZeAW0kYpXYI8_kzaNs6Dupdf2Mko/edit?usp=sharing this step: 1. my formula in sheet REKAP...
www.excelforum.com
susan