Not Found
Sorry, but you are looking for something that isn't here.
Handy Excel Tips
MS Excel Tips, Shortcuts and Techniques to Increase Your Excel Productivity
About the Author
List of Articles
Most Popular Posts
How to unlock keyboard??
Insert Excel Spreadsheet into Microsoft Word Document
Performing Two-Criteria Lookup
List Worksheet Names
Generating list of contents of any folder
How to copy and paste values in filtered data?
How to find or replace asterisk(*) and question mark(?) in MS excel??
Dragging a formula down
Sumif array formula OR countif function
SUM(IF()) array formula
Excel Shortcuts
Custom Right Click Menu
Alphabetic Series on Excel
Accessing other worksheets in a workbook faster
Naming cells in Excel
Run Command shortcuts
How to add "My Recent Documents" to the Start Menu?
Dragging a formula down
See all Formulas at Once
Delete Excel chart
Hide and unhide rows and columns without a mouse
Mouseless Dragging of the topmost cell to cells below
Excel keyboard shortcuts List
General Tips
Save a new worksheet directly in the desired folder
Choosing your own "Save File" location
How to unlock keyboard??
10 ways to open excel faster
Excel's Images and Screenshots
Splitting Large Excel files into smaller parts using Winzip
Insert Excel Spreadsheet into Microsoft Word Document
Putting Borders around bunch of non-adjacent Cells at once
Selecting Multiple Worksheets
How to sum values in a filtered list???
Converting Text to Columns in Excel
Moving between multiple excel Workbooks
How to get rid off #### entries in excel???
Avoiding blank cells
Excel to PDF Converter
MiniStore
Recent Posts
Custom Right Click Menu
Reader’s Questions - Performing two-way look up
How to copy and paste values in filtered data?
Save a new worksheet directly in the desired folder
Freezing Formulas
MyBlogLog
Subscribe
RSS Feed
Get Excel Tips by Email
Recent Comments
Trev
: Thank you!
sanjesh Dubey
: it was a great job .Examples used would help a lot to grab the concept quickly
K
: Exactly what I was looking for. Thank you!!!
Anne
: Thanks Shikha! Very useful!
maie
: Thank you, I breathe again.
Don
: THANKS!!!
nick
: Thanks. Very helpful.
Cristina
: @Gautam, could u maybe e-mail me that Macro? cause i have no idea how to make this one. i need all...
jamie
: very useful thanks a lot. Re: Johns comments... this will not happen if you follow the instruction...
Talha
: Or it could be this formula =LOOKUP(2,1/((A2:A7=E2)*(B2:B7=F2)),C2:C7) try this in cell (E17)
Abhilash
: Thank was really useful. I am saved writing lines of code to perform this operation.. :)
Polika
: Thanks
Clever Excel Formulas
Reader's Questions - Performing two-way look up
How to copy and paste values in filtered data?
Freezing Formulas
Sumif array formula OR countif function
How to find or replace asterisk(*) and question mark(?) in MS excel??
Generating list of contents of any folder
Performing Two-Criteria Lookup
Formatting the cell as text
Selecting non-adjacent cells in excel
Pivot table or countif function???
Logical Excel Formulas
SUM(IF()) array formula
Excel frequency function or simple logic??
Excel Macros
Finding external links
List Worksheet Names
Excel Functions
Finding external links
Indirect Function
Alphabetic Series on Excel
Is there any de-concatenate command??
Changing case in Excel
Concatenate function
Highlighting duplicate values in adjacent cells
Offset function in conjunction with Sumif
Excel Online
Now share your excel sheets using Microsoft's Office Live Workspace
Excel Formula Bar
Display separate taskbar button for every open excel workbook
Compare multiple excel sheets at once
Close
Social Web
E-mail
del.icio.us
Digg
Furl
Netscape
Yahoo! My Web
StumbleUpon
Google Bookmarks
Technorati
BlinkList
Newsvine
ma.gnolia
reddit
Windows Live
Tailrank
9rules Clips
E-mail It
To Address:
Your Name:
Your Address: