Page Loading... please wait!


This message not going away?
Ensure Javascript is on and click the box
Unregistered? Register for a user account. Home :: Online Shop :: Downloads :: Forum   

Choose country


France United States



Partners


Poll

How many distributions should we describe in one magazine?

[ Results | Polls ]

Votes: 594
Comments: 0



Downloads



Articles published in this section are provided only for our visitors' personal usage.
Any further publication and dissemination of these articles without direct permission given by Oxy Press LLC is prohibited.
Download file name: OpenOffice.org :: Using formulas to find Calc data

Calc offers numerous methods to find data in a sheet. For example, Edit -> Find & Replace moves the display cursor based on simple and advanced searching. Use Data -> Filter to limit what is displayed rather than simply moving the cursor.
Calc also offers lookup functions used in formulas. This article shows how you can search data using VLOOKUP, HLOOKUP, LOOKUP and MATCH functions. It will be explained with simple and advanced examples.


Author: Andrew Douglas Pitonyak
Version: File size: 172.83 Kb
[ Home page ]
[ Editor review | Report broken link ]

Download rating details
Total votes: 0
Overall rating: 0



Newsletter

You are currently not logged in, but you can still subscribe to our newsletter.

Subscribe Now!

On sale

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5074

Online

There are 12 unlogged users and 0 registered users online.

You can log-in or register for a user account here.

Login





 


 Log in Problems?
 New User? Sign Up!

Linux Identity Set

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5053

Linux Identity Office

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5052

Linux Identity Set

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5040

Linux Identity Office

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5039

Linux Identity Kit

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5024

Linux Identity Set

http://www.linuxidentity.com/us/index.php?name=News&file=article&sid=5023