excel & table

I am trying to find result of sort data in table with specific criteria for example : The picture of excel-table that i trying to figure it out yellow is ALL-JOB fill by user RED is Unfinish JOB sort by "START DATE" Green is Completed JOB sort by "END DATE" and "JOB ID" i need to sorting data...

I have provided this request before. Tables were not visible in that thread. So creating a new one. Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Table in Worksheet 1 (Main Worksheet). Shown entries for a project with two units - Unit 1 and...

Hi, I have a dynamic table that I'm trying to sort by the value of the cells (that have duplicate values) in the first column A. I would start of with this: <tbody> Column A Column B Column C 3 cat Cats Rule#1 3 cat Cats Rule#2 3 cat Cats Rule#3 1 dog Dogs Rule#1 1...

Hello everyone, I have a spreadsheet at work that requires me to put the same information into two separate tables on two separate sheets. The master list containing all of the information unfiltered is on sheet name Raw and is shown below. Each "Name" has their own sheet with an identical...

I have 3 inputs Say product price,loan period and monthly product sales. What I want is if the user changes the loan period I want to populate the table accordingly. I just can't figure out a way. If you think there is better way to show what I am trying to show as a table format I am open to...

Hi, Is it possible to associate =today() to if this is an example: the current tab i'd like for it to change from EMEA to AMER if today the work time is 10 PM onwards and be change to EMEA if the shift was changed to 5PM, is that possible can i kindly ask for help please thank you Absent AB...

Hi, Hoping someone could help me with this problem below. I have recreated an excel sheet below. Column 1 is the color, Column 2 is the response (Yes/No), and column 3 is blank. Is there a formula I can write in column 3 that will help me identify if, for a specific color, only "No" was...

I am a student in Excel with limited knowledge. I was trying to do one project and while creating a table I choose "my table has Headers". My question is; how can I remove Filters arrows from the header?