1. How to Add a Check Box in Excel ??
(for example if you want to include a form into you sheet)
1. To add a check box in Excel,
2. go to the Developer tab,
3. select Insert,
4. Form Control, Checkbox.
5. Drag the shape to add your text box.
To edit the location,
1. text,
2. appearance,
3. options - right click on the checkbox.
2. How to find Top & Least Sales Person Name in a Excel Sheet with VLOOKUP function ??
You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function.
In the pictured example, MIN and MAX are nested to return the name of the salesperson associated with those functions.
1. The formula in cell F6 is =VLOOKUP(MAX(C8:C19),C8:D19,2,0)
2. The formula in cell G6 is =VLOOKUP(MIN(C8:C19),C8:D19,2,0)
The VLOOKUP function’s fourth argument is range_lookup.
For the MIN and MAX functions, the range_lookup is 0, which could have also been written as
FALSE or simply omitted altogether. This deals with your desire and expectation that an exact lookup
value will be found. In this example, you know that a specific minimum and maximum number will be found in the list in column A.
NOTE:: Please Suggest us if you have better Solutions
(for example if you want to include a form into you sheet)
1. To add a check box in Excel,
2. go to the Developer tab,
3. select Insert,
4. Form Control, Checkbox.
5. Drag the shape to add your text box.
To edit the location,
1. text,
2. appearance,
3. options - right click on the checkbox.
2. How to find Top & Least Sales Person Name in a Excel Sheet with VLOOKUP function ??
You can nest a function as the lookup_value argument with VLOOKUP, to return an item relating to the lookup_value function.
In the pictured example, MIN and MAX are nested to return the name of the salesperson associated with those functions.
1. The formula in cell F6 is =VLOOKUP(MAX(C8:C19),C8:D19,2,0)
2. The formula in cell G6 is =VLOOKUP(MIN(C8:C19),C8:D19,2,0)
The VLOOKUP function’s fourth argument is range_lookup.
For the MIN and MAX functions, the range_lookup is 0, which could have also been written as
FALSE or simply omitted altogether. This deals with your desire and expectation that an exact lookup
value will be found. In this example, you know that a specific minimum and maximum number will be found in the list in column A.
NOTE:: Please Suggest us if you have better Solutions
Tag :
MicroSoft Office
