Hi In that case you will get 1st lowest value!
Are you looking for both values ? Cheers!! On Tue, Jul 8, 2014 at 9:36 PM, Deb <b.debapr...@gmail.com> wrote: > Hi Vabz, > > Thanks for the quick reply and its wonderful. But i have noticed there is > an issue. Suppose I have 6 cells where first 3 numbers are 1 and last 3 > numbers are 2. Then its taking as 1. So my question is suppose if there is > 2 similar value which one will it choose? I have attached the same file. > > On Tuesday, 8 July 2014 09:43:53 UTC+5:30, Deb wrote: >> >> Hello All, >> >> I need a quick help. I have a work to select most rated pics using excel. >> I have attached a file here. I am sending pics to my client and they will >> choose what they like and send me the number of the pics. and i have to >> select most liked pics among them. Can i use any formula to select it >> automatically. There are thousands of pics so doing it manually will have a >> problem. Also please suggest if there is any alternative. >> As an example, i will send the pics with the number like 2,3,4,5,6,7. I >> will send it to 20 people and they will reply with the number they like, so >> if pic no 3 has been selected by 15 people then it will be most rated. so >> how can i do it with excel? >> >> Thanks in advance. >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
