i will need to create 2 tables based on certain criteria.
Few things to note :
1. "Master" worksheet is the master data set where i will keep updating it. New data will be added manually by me on the ongoing basis. I will need to extract the data from this master sheet and display them dynamically based on certain criteria
Part 1 : Filter - Date Worksheet
There are 4 filtration criteria here:
1. Date 1 - Date picker
2. Date 2 - Date picker
3. Player 1 - this will be defaulted based on what is entered 'Data' sheet D1
4. Surface - Will be a drop down with 4 values : Hard , Clay, Grass, ALL
Win % - take the number of wins / no of matches over the period specified
Once i selected the criteria, then the table will need to be automatically updated based on the criterias.
All the data are available from the 'master' worksheet. With the exception of 'Result' column. You will need to write a formula based on whether player 1 name is in the Winner_name or Loser_name column.
2. Repeat the above for player 2.
3. There is another data to populate which is Head 2 Head (Starting column AC). Based on the criteria, you just display only the data between Player 1 and Player 2.
Part 2: Filter - Last X games
Similarly to Part 1, the only difference is the filter is based on the last X games. For example if i select Last 10 games, and surface = ALL,
12 pekerja bebas membida secara purata $45 untuk pekerjaan ini
I am offering my services in short notice , my relevant skills and experience please consider me and give me a chance to impress by my quality work services.