Excel SUMIFS and VLookup for multiple columns and two sheets
- Stanje: Closed
- Nagrade: $30
- Prejetih vnosov: 7
- Zmagovalec/ka: hopkovictoria
Navodila natečaja
Hello - I have a simple contest for Excel Masters for a spreadsheet:
Period Flow thru Worksheet:
Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id”
Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A)
Criteria 3: Period Flow Thru Worksheet row 3 Period, Week, Year with Calendar Tab columns AK (ReportingWeekPeriodYearString)
That value goes into Week three tab column E. Match column B with with “Sales Tab” column b “restaurant_id”
The value in Period Flow thru Worksheet column U goes into week three column G matching Week 3 tab column B with Period Flow thru Worksheet column S
Priporočene spretnosti
Delodajalčev feedback
“Excellent Excel Skills”
jasonsetzer81, United States.
Najboljši vnosi tega natečaja
-
hopkovictoria Ukraine
-
kavinishan Sri Lanka
-
hopkovictoria Ukraine
-
ovaissss Pakistan
-
gellieann3 Philippines
-
ovaissss Pakistan
-
gellieann3 Philippines
Javna tabla za pojasnila
Kako začeti z natečaji
-
Objavi svoj natečaj Hitro in preprosto
-
Prejmi na tisoče vnosov S celega sveta
-
Dodeli natečaj najboljšemu vnosu Prenesi datoteke - Preprosto!