Get a month of TabletWise Pro for free! Click here to redeem

0502 Go To (Special) - Formulas Without Errors

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.17
You save:  د.إ146.91
List Price:  A$201.46
You save:  A$57.56
List Price:  ৳11,880.65
You save:  ৳3,394.71
List Price:  CA$190.27
You save:  CA$54.36
CHF 94.09
List Price:  CHF 131.73
You save:  CHF 37.64
List Price:  kr922.14
You save:  kr263.48
List Price:  €123.82
You save:  €35.37
List Price:  £110.81
You save:  £31.66
List Price:  HK$1,085.07
You save:  HK$310.04
List Price:  ₹10,524.04
You save:  ₹3,007.08
List Price:  RM597.26
You save:  RM170.66
List Price:  ₦54,219.52
You save:  ₦15,492.40
List Price:  kr1,320.98
You save:  kr377.45
List Price:  NZ$212.97
You save:  NZ$60.85
List Price:  ₱6,921.33
You save:  ₱1,977.66
List Price:  ₨23,247.81
You save:  ₨6,642.70
List Price:  S$194.74
You save:  S$55.64
List Price:  ฿4,384.27
You save:  ฿1,252.74
List Price:  ₺961.22
You save:  ₺274.65
List Price:  R2,346.24
You save:  R670.40
Already have an account? Log In


Hi. In this video, let me give you a task. On the left hand side lies a data table. And you will notice a lot of blank cells numbers thrown across the entire region. Some of these cell may contain a formula, which is something like this when I write equals 10, plus any number divided by any number, or any kind of formula, which is throwing a result in a numeric form. Now, this could be an Excel sheet which your colleague would have worked upon six months back, and when you're taking a handover, you want to find out what last minute adjustments happened while he was working.

So I want to find out which cells are those. If you were to do this using traditional method, you'd have to double click on each and every cell to find that out, isn't it? Now, if you know the right technique, this happens in less than 10 seconds. Let's see. If I choose the data, I press Ctrl G Click on the button thing special. Next, I target the ones which says formula which are carrying numbers formula, which are doing number as an answer.

As I press Ok, I see one of those cells. In fact, two of those cells are getting highlighted. Now just to hold on to their presence, I'm going to color them so home, and here goes the color. Now, both these cells if I double click upon them, one contains 10 plus something, the other contains 766 into 98%. Imagine if you were to find this in a really large data, it would have been something like finding a needle in a haystack. This could also be used beneficially if you are belonging to the domain of forensic audit.

A lot of times you get data from the client staff and you want to vet this and you want to do a sanity check whether the data is containing any internal adjustments and if so, then you can go back to the client and ask for the reason. So this was Ctrl G formula with numbers

Sign Up