Publicar un concurso

Vlookup and Countif

Estado: Closed
Premio: $20
Propuestas recibidas: 4
Ganador: elqueabandona

Winner

Resumen del 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

Publica un concurso similar

Comentarios del empleador

“Very fast and thorough”

jasonsetzer81, United States.

Principales propuestas de este concurso

elqueabandona Argentina

0
tuSOLUCION Uruguay

0
jaylancer43 India

0
elqueabandona Argentina

0

Ver más participaciones

Tablero de aclaración pública

tuSOLUCION
- 6 años atrás
The winner numbers are not correct
- 6 años atrás
jaylancer43
- 6 años 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 !
- 6 años atrás
Ashisjena2015
- 6 años atrás
Can you explain me in more detail so that I will help you right now.
- 6 años atrás
1. Organizador del concurso
  - 6 años atrás
  I am trying to get the count of edit miles (column R on Raw Data tab) based on ranges
  - 6 años atrás
priyapatel389
- 6 años atrás
there is no column R.
- 6 años atrás
1. Organizador del concurso
  - 6 años atrás
  There is column R on "Raw Data" tab
  - 6 años atrás