Hi
Below is question from that i am not resolve Ratings question rest i know how to do this
Can you please tell me for this question(In Column J, show the ratings to all the customers on the basis of billing amount. Refer to the conditions mentioned in the range A1:C11 on reference sheet)
In Column I give the ranking to all the customers i.e. Rank 1 to the highest billing , Rank 2 to the second highest billing and so on
In Column J, show the ratings to all the customers on the basis of billing amount. Refer to the conditions mentioned in the range A1:C11 on reference sheet
In Cell N1, display a drop down showing all the months i.e January, February till December
In Cell N2, display a drop down showing three products i.e. Gold, Silver and Diamond
In Cell N3, apply a function which should search the values of N1 and N2 in the range A17:E30 on reference sheet and show the corresponding Sales
Below is question from that i am not resolve Ratings question rest i know how to do this
Can you please tell me for this question(In Column J, show the ratings to all the customers on the basis of billing amount. Refer to the conditions mentioned in the range A1:C11 on reference sheet)
In Column I give the ranking to all the customers i.e. Rank 1 to the highest billing , Rank 2 to the second highest billing and so on
In Column J, show the ratings to all the customers on the basis of billing amount. Refer to the conditions mentioned in the range A1:C11 on reference sheet
In Cell N1, display a drop down showing all the months i.e January, February till December
In Cell N2, display a drop down showing three products i.e. Gold, Silver and Diamond
In Cell N3, apply a function which should search the values of N1 and N2 in the range A17:E30 on reference sheet and show the corresponding Sales