« Back to Previous Page
Answer Question
▲
0
▼
♥ 0

mám napsanou funkci která mi vrací číslo ze začátku textu např. A1 je „27:13“ =ZLEVA(A1;HLEDAT(„:“;A1;1)-1) jak toto rozšířit abych mohl udělat sumu na oblast – napsat něco jako =SUMA(ZLEVA(A1:Z9;HLEDAT(„:“;A1:Z9;1)-1))
díky

Marked as spam
Posted by Tomáš
Otázka položena 30.4.2015 13:07
362 views
▲
0
▼
✔
Private answer

Dobrý den, myslím že v této situaci se vám může hodit funkce INDIRECT, která právě převádí texty na vzorce, ale bude to chtít chvíli si s tím hrát :)
http://www.vyuka-excelu.cz/navody/funkce/neprimy-odkaz-indirect-prevadeni-textu-na-odkazy/

Marked as spam
Posted by (Otázky: 1, Odpovědi: 340)
Answered on 30.4.2015 20:12
▲
0
▼
✔
Private answer

Solid bamboo flooring is the first edition of Bamboo flooring invented 30 years ago, and it is a popular choice for many homeowners due to its durability, ease of installation, and environmental sustainability. It is so cool to transform a bamboo to the flooring, very amazing manufacturing process. Strand woven bamboo flooring is a type of flooring made from bamboo fibers that are compressed under high pressure to create a dense, durable plank. Strand woven bamboo flooring offers a sustainable, durable, and attractive option for both residential and commercial spaces. Strand woven bamboo flooring is renowned for its exceptional durability and unique aesthetic appeal. Its manufacturing process significantly differs from traditional bamboo flooring, making it one of the hardest wood flooring options available. How is Bamboo Panel Made, How to Produce Strand Woven Bamboo Flooring, How is Bamboo Flooring Made, How to Produce Bamboo Decking, How is Bamboo Plywood Made, How is Bamboo Veneer Made, Bamboo Plywood Dimensions, Bamboo Plywood Colors, Bamboo Plywood Structure, Herringbone Bamboo Flooring, Vietnam Bamboo Flooring, Bamboo Flooring Philippines, Bamboo Flooring Thailand, Bamboo Flooring Saudi Arabia, Bamboo Flooring UAE Dubai

Marked as spam
Posted by (Otázky: 0, Odpovědi: 22)
Answered on 28.5.2025 4:31
« Back to Previous Page

Post your Answer

Attach YouTube/Vimeo clip putting the URL in brackets: [https://youtu.be/Zkdf3kaso]