How to avoid the RANK function finding equal results Jun 20, 2012
How to solve the problem of the rank function returning the same value.
Home // Blog & Excel Tips // 77
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
Drop down cells and looking up related information Jun 20, 2012
How to base a drop down list on the outcome of another dropdown list
How to rank items that have the same rank?? Jun 20, 2012
How to address the issue where the rank of items needs to be the same but the Excel RANK function ignores all but one of the ranks
Green Marks inside Excel cells Jun 20, 2012
Explanation of what the little green notes inside Excel cells are and how to use them
Conditional Formatting across sheets Jun 20, 2012
How to perform a conditional format that needs to look at a different sheet.
AND and OR functions Jun 20, 2012
The question is a bit unclear but from what we see you should be using the AND and OR commands. See how to use them on https://www.auditexcel.co.za/AND_OR.html . Hope this helps, otherwise it is better to send a spreadsheet.
Pulling every 17th cell into a consecutive list Jun 20, 2012
How to pull every xth cell into a consecutive list using the OFFSET function
Consulting
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
Live Training
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.