Advanced Filter and Dynamic table in Excel

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

Calculated Field

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,

Kemahiran: Excel, Visual Basic

Lihat lagi: control dynamic table excel, dynamic html table excel php, dynamic html table excel, dynamic table fill excel, filter data dynamic table javascript php, table excel filter, excel vba advanced filter unique, advanced filter excel, excel vba advanced filter multiple criteria, excel vba advanced filter copy to another sheet, excel vba advanced filter multiple criteria not equal, excel vba filter pivot table based on multiple cell values, advanced filter vba code excel, advanced pivot table excel 2010 pdf, excel vba advanced filter, excel advanced filter date range, excel advanced filter between two dates, how to use advanced filter in excel, dynamic table excel, dynamic advanced filter excel

Tentang Majikan:
( 4 ulasan ) Hawthorn East, Australia

ID Projek: #29426949

Dianugerahkan kepada:


Excel is my expertise and I can help you with that. I have 2 years of experience as reliability engineer responsible for equipment failure data analysis. I am familiar with using excel for data mining, data cleaning an Lagi

$25 AUD dalam 5 hari
(3 Ulasan)

12 pekerja bebas membida secara purata $45 untuk pekerjaan ini


Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sam Lagi

$80 AUD dalam 2 hari
(404 Ulasan)

**** willing to work on dynamic tables ***** Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - • Macros • Formulae • V Lagi

$30 AUD dalam sehari
(53 Ulasan)

hi, I am an expert in MS Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Lagi

$10 AUD dalam 7 hari
(15 Ulasan)

Hi Sir, Checked the Project: Advanced Filter and Dynamic table in Excel I carefully read your project description & I can handle this in my best care and professional manner. I am an expert in excel. I ensure to com Lagi

$100 AUD dalam sehari
(15 Ulasan)

I can help you successfully. Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with Excel pro Lagi

$20 AUD dalam sehari
(9 Ulasan)

Hi, Greetings! ✅checked your project details. I can help you filter data I have completed the M.SC. (Statistics) . I Have 4 years’ experience with Data entry, Data analysis, and MIS Management. I have strong analysis, Lagi

$25 AUD dalam 7 hari
(11 Ulasan)

❤Excellent skill in the word,excel,pdf,with upto 1 year experience Please read my Reviews from below link❤ ✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅ These are the recent projects solved https://www.freelancer.com/projects/excel/conversion-rat Lagi

$100 AUD dalam 2 hari
(6 Ulasan)
(2 Ulasan)

i am studying advance excel word PowerPoint knowledge of computer hard working low price work for ready

$30 AUD dalam 2 hari
(0 Ulasan)

I have a experience certificates I will finished the works on particular time and particular days please provide the following project

$14 AUD dalam 3 hari
(0 Ulasan)

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.

$25 AUD dalam 7 hari
(0 Ulasan)