Pubblica un concorso

Vlookup and Countif

Stato: Closed
Premio: $20
Proposte ricevute: 4
Vincitore: elqueabandona

Winner

Descrizione del concorso

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

Competenze consigliate

Excel

Winner

Pubblica un concorso simile

Feedback del Datore di Lavoro

“Very fast and thorough”

jasonsetzer81, United States.

Le migliori proposte per questo concorso

elqueabandona Argentina

0
tuSOLUCION Uruguay

0
jaylancer43 India

0
elqueabandona Argentina

0

Visualizza altre proposte

Bacheca pubblica per chiarimenti

tuSOLUCION
- 5 anni fa
The winner numbers are not correct
- 5 anni fa
jaylancer43
- 5 anni fa
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 anni fa
Ashisjena2015
- 5 anni fa
Can you explain me in more detail so that I will help you right now.
- 5 anni fa
1. Titolare del Concorso
  - 5 anni fa
  I am trying to get the count of edit miles (column R on Raw Data tab) based on ranges
  - 5 anni fa
priyapatel389
- 5 anni fa
there is no column R.
- 5 anni fa
1. Titolare del Concorso
  - 5 anni fa
  There is column R on "Raw Data" tab
  - 5 anni fa