Get The Maximum Text

[Kenshin]

Hi expert need help again to make this work, please take a loook at the file


thanks

 

[vletm]

Kenshin
Would You reread https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/ ?

How to get the Best Results at Chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches.
• When drafting a question, try and lay out the question in a clear and concise way.
• Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
• Don't leave out information more info is better

Your thread title ... won't 'help anybody' in the future ... or how?

 

[Kenshin]

Done fix it

 

[vletm]

Kenshin
The Maximum text ...
Do You mean text above 'Voucher/Invoice'?
... which can copy .. and paste special (values) to needed cells to B-column?

 

[Kenshin]

No i need company name copy on column B with formula

 

[bosco_yip]

Try...................

In B2, copied down :

=IF(ISNUMBER(A2),LOOKUP(1,0/(C$2:C2="Voucher/Invoice"),C$1:C1),"")

Regards
Bosco

 

[Kenshin]

As usual is works Bosco, thanks for the help


regards
Kenshin