Publicar um Concurso

Vlookup and Countif

Status: Closed
Prêmio: $20
Inscrições Recebidas: 4
Vencedor: elqueabandona

Winner

Síntese do concurso

Hello - I am attching a worksheet that I want to count how many of the orders had an override within x range (<5, 5-10, 10-15, 15-20, 20 - 25, 25 - 30, 30- 35, 35 - 40, >40) and aslso what total % of orders had an overide. Column R on Raw Data tab has the overrides (called edit miles) and you will match column A (restaurant_id) on "Raw Data" tab to column A on "Total #" Tab. Please let me know if you have any questions. First to finish in entirety wins

Habilidades Recomendadas

Excel

Winner

Lance um Concurso Como Este

Feedback do Empregador

“Very fast and thorough”

jasonsetzer81, United States.

Principais inscrições deste concurso

elqueabandona Argentina

0
tuSOLUCION Uruguay

0
jaylancer43 India

0
elqueabandona Argentina

0

Ver Mais Inscrições

Painel de Comentários

tuSOLUCION
- 5 anos atrás
The winner numbers are not correct
- 5 anos atrás
jaylancer43
- 5 anos atrás
Hello,
Please review the values of my entry. I see that you had applied a filter on column "edit_miles" for greater than 10 so I suppose edit_miles for less than 10 needs to be ignore. Please let me know if this is incorrect.

Thanks !
- 5 anos atrás
Ashisjena2015
- 5 anos atrás
Can you explain me in more detail so that I will help you right now.
- 5 anos atrás
1. Proprietário do Concurso
  - 5 anos atrás
  I am trying to get the count of edit miles (column R on Raw Data tab) based on ranges
  - 5 anos atrás
priyapatel389
- 5 anos atrás
there is no column R.
- 5 anos atrás
1. Proprietário do Concurso
  - 5 anos atrás
  There is column R on "Raw Data" tab
  - 5 anos atrás