Get instant live Excel expert help to learn how to create and adjust tables in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Cross referencing so countries that appear in both tables are highlighted. COnditional formatting
Solved by I. B. in 12 mins
I need to compare three data tables with different information
Solved by E. D. in 20 mins
I need assistance with basics of pivot tables in excel
I can send you the spreadhseet
Solved by K. A. in 29 mins
I have three pivot tables which I want each time I update the pivot, it should automatically update a summary sheets.
how can I achieve it.
Solved by S. S. in 25 mins
I have two tables (say of size 100x2 and 150x2)with Description in one column and Quantities in the other column, in both the tables. I want to compare both the tables and extract the minimum quantity against a particular description row.
Solved by E. H. in 22 mins
Hello, I am trying to combine an IF and VLOOKUP formula. I am trying to build an invoice sheet and I want to make it so if there is no code in the Product code space then Product name, description and unit price will be blank.
After researching I found this =IF(ISNA(VLOOKUP(A20,Poducts,2,FALSE)),"",VLOOKUP(A20,Products,2,FALSE))
But it is not working as the N/A does not dissapear from the spaces with no codes.
In my workbook I have a sheet called clients, products and Invoice with the tables carrying the same names for referring Vlookup.
Any help is appreciated.
Solved by T. L. in 25 mins
I need to learn how to create pivot table in excel from a very complex data set with bandwidth, locations etc...
Solved by T. A. in 16 mins
I am trying to create formulas off of pivot tables and and using abs formula in excel, is there a workaround to be able to drag a formula down and have the data translate to each row?
Solved by O. E. in 26 mins
Is there a way i can have a drop down selection fill out multiple rows and columns by selecting it? I would like to select the 120VAC drop down in tester type ( on sheet 3), and it fill in everything that says "120VAC" on the tables tab to Sheet 3 bill of materials
Solved by X. L. in 28 mins
I need help with vlookup. I have to compare two columns in excel for differences
Solved by V. J. in 15 mins