Ask Your Question

jouslain's profile - activity

2016-03-02 00:00:19 +0200 received badge  Famous Question (source)
2016-03-02 00:00:19 +0200 received badge  Notable Question (source)
2016-03-02 00:00:19 +0200 received badge  Popular Question (source)
2014-08-15 19:39:13 +0200 received badge  Famous Question (source)
2014-08-15 18:46:07 +0200 asked a question Background items pop-up after animation

I'm working on presentation about antihypertensive drugs.

http://www.mediafire.com/view/wme8kc2...

However as it slide#4, even I set the picture to appear "in front of" the "diuretics" text, the text "diuretics" keep pop up after running animation.

If I want to keep the text "diuretics" "behind" my pictures for all the times the pictures on screen, what should I do?

PS. - I embeded font in files, hoping not to cause messiness in appearance because I used downloaded font in this presentation - Some texts are in Thai.

Thanks

2014-07-11 16:10:11 +0200 received badge  Notable Question (source)
2014-07-10 19:13:43 +0200 received badge  Popular Question (source)
2014-07-10 17:02:38 +0200 commented question Completing table using information from other spreadsheet

Sorry for not providing adequete information

First of all, 'my other spreadsheet is originally another .ods file, but now I have copy&past it to be another sheet in the same file.

Thanks for your advice, I tried VLOOKUP but still getting error

May I asked you for a favor?

The VLOOKUP script I typed shown here

[IMG]http://i1328.photobucket.com/albums/w525/siravac/Screenshot-2_zps60608e0e.png[/IMG]

The spreadsheet providing values for Impact Factor is here

[IMG]http://i1328.photobucket.com/albums/w525/siravac/Screenshot-1_zpsca61cd75.png[/iMG]

I also upload the problemed file here

http://www.4shared.com/file/PfCOaeQ2b...

Thank you

2014-07-10 17:01:46 +0200 answered a question Completing table using information from other spreadsheet

Sorry for not providing adequete information

First of all, 'my other spreadsheet is originally another .ods file, but now I have copy&past it to be another sheet in the same file.

Thanks for your advice, I tried VLOOKUP but still getting error

May I asked you for a favor?

The VLOOKUP script I typed shown here

[IMG]http://i1328.photobucket.com/albums/w525/siravac/Screenshot-2_zps60608e0e.png[/IMG]

The spreadsheet providing values for Impact Factor is here

[IMG]http://i1328.photobucket.com/albums/w525/siravac/Screenshot-1_zpsca61cd75.png[/iMG]

I also upload the problemed file here

http://www.4shared.com/file/PfCOaeQ2b...

Thank you

2014-07-10 09:18:10 +0200 asked a question Completing table using information from other spreadsheet

Dear everybody,

I'm working about listing of published scientific article for my organization now, and I have to complete the table that look like this one.

image description

I'd like to fill the 'AQ' column with the values called Impact Factor (which is something like 'ranking' for each scientific journal) and those values can be found in my other spreadsheet which look alike these

image description

For example, I'd like to fill the value '0.589' (Impact Factor, from the first row of the second spreadsheety) in every the 'AQ' columns (of the first spreadsheet) whose 'AF' (ISSN, a coding number for each scientific journal) is 0001-5512

If this is confusing, I'm sorry but I find hard to explain

Thanks a lot