Opret Konkurrence

Vlookup and Countif

Status: Closed
Præmier: $20
Modtagne indlæg: 4
Vinder: elqueabandona

Winner

Konkurrence Instruktioner

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

Anbefalede færdigheder

Excel

Winner

Opret en konkurrence som denne

Arbejdsgiverfeedback

“Very fast and thorough”

jasonsetzer81, United States.

Bedste indlæg fra denne konkurrence

elqueabandona Argentina

0
tuSOLUCION Uruguay

0
jaylancer43 India

0
elqueabandona Argentina

0

Se flere indlæg

Offentlig Præciserings Opslagstavle

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