Yarışma İlan Edin

Vlookup and Countif

Durum: Closed
Ödül: $20
Alınan Girdiler: 4
Kazanan: elqueabandona

Winner

Yarışma Özeti

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

Aranan Beceriler

Excel

Winner

Benzer Yarışma İlan Et

İşveren Geribildirimi

“Very fast and thorough”

jasonsetzer81, United States.

Bu yarışmadan başlıca girdiler

elqueabandona Argentina

0
tuSOLUCION Uruguay

0
jaylancer43 India

0
elqueabandona Argentina

0

Daha Fazla Girdi Görüntüleyin

Genel Açıklama Panosu

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