Functia VLOOKUP 11 exemple neobisnuite, functia hlookup,functia lookup tut.42

Highline Excel Class 40: VLOOKUP11 Unusual Examples

Contine si functia trim care elimina spatiile se adauga zero ca sa converteasca din string in numar deoarece am folosit functia trim aferenta string-urilor.

Sau o varianta buna se selecteaza column_one ->data->text to columns->se alege space si suprima automat spatiile.

Minutul 21  functia MID de extragere a unui subsir dintr-un sir.

To convert text into number add zero after mid function.

Conversie dintr-o cotatie in alta ex.zece.

Highline Excel Class 41: HLOOKUP ROWS Horizontal Lookup

E1.7.1 HLOOKUP Across Two Worksheets in Excel

Highline Excel Class 42: Versatile LOOKUP function 10 Examples->Detaliaza functia Lookup

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: