Formula changing when sorted
Hi all, I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …
Multiple tables – Sorting
Hi, My problem is that I have two tables and one table that is combining (adding up) the two tables together and I want to be able to sort all 3 tables …
Copying the sorted data and it’s relevant columns together in new columns
Hi everyone. Consider there are 3 columns. I want to sort the 3rd column, in a way that the sorted data of the 3rd column are now in the 4th column. I do this …
Computer Teacher
I am working with a listing of 10 and for each I have 6 columns – last name, first name, SS#, Salary, Date of Hire, Department. I want to create reports …
IT
Hi there, I have a list of 35k contacts, I need to sort unique after unique. I sorted them by “Domain” column, now I need to sort 1st unique …
Sorting Extensive Dates and Times
Everyday I pull up a report indicating when someone took a course for my work. Instead of pulling up in chronological order, the report shows the Day of the …
eliminate from list
Dear Excel Geek, I need your help in solving a problem. I have two lists of suppliers. One is of suppliers I need to track, the other a list of all …
Table Slicer sorting help! Excel 2016
Excel 2016 – windows 10 I have a large table with hundreds of rows… I want to be able to filter my “description” column with a slicer …
Data Searching & Linking between two excel files.
I have two excel files. One file is having all the data…columns like sr.no., product name etc. What I want is that… If in other excel file, I enter …