I have two workbooks. Workbook A has 1 worksheet, and two tables. Table1: Containing Student_ID, Student_Name, Student_Age Table2: Containing Student_ID, Student_TestResult Workbook B has 1 workshet, with 1 table. Table3: Containing Student_ID, Stude
i have four columns that are simplified and look like this item quantity item quantity 102 --- 1 --- 102 --(-3) 103 --- 1 --- 104 --(-1) 105 --- 1 --- 105-- (-1) i want excel to highlight 104 in the third column because it does not exist in the first
I am using Excel 2016 from Office 365 on Windows 10 and I can't get my horizontal bar chart (stacked) to show my 3 sets of values on each stacked bar. Can anyone help? This is supposed to be a chart like a Gantt chart to show the progress of a progre
A quick questioon about a formula. I search a method that will do this : it will check a column and if it meets a value, it should determine if this value is at least in one of two ranges (16-20 or 80-84) and it displays the number of values in these
I'm working on an Excel spreadsheet and when I use a SUM formula in a cell and then I select columns, it returns 0. I think that it's due to the double quotes in the cell. I tried to format the cells but it still returns 0. I'm using Microsoft Office
I have a question on how to find the maximum total freight weight for the truck numbers and colors specified below using excel spreadsheet? FYI just by looking at the numbers and color of the trucks, it is easy to identify that the green trucks have
So when I am using excel, sometimes a formula used will prompt an answer such as 67.9999999. When I then paste this into another cell which I have formatted to 2 decimal places it shows 68, but in the top formula bar it will still show it as 67.99999
Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested. I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes h
Need help i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested. Can create multiple pivot table but would be ending up having 10+. So is it possible and if yes how? (tried google and v
I have a folder of 90 excel files each named according to the date of the data within and where the single worksheet in each file has the exact same name. I need to combine the worksheets into a single worksheet, which I can easily do, but I need to
I haven't got any problem, but I ask myself a question. In my current project, I use a lot of formulae and I group them into few cells. So I use very few tables and very few simple formulas but each table and each formula could be cut into simpler fo
So I have two sheets with same type of data but for different months from different systems. I want to see if both systems have same data for each ID and if for each SK ID the org ID and Entity ID matches. First sheet has 50,000 columns and second on
I've got a problem with the vlookup() function. I search a text in a table (A column) and want to return the E-column value (E10). However, vlookup() returns the last value of the column (E35). I guess I made a mistake but I've really no clue about i
I have two spreadsheets right now and I'm trying to figure out a way to easily pull data from sheet 1 that matches corresponding data in sheet 2. Sheet 1: companyname companyid Sheet 2: companyname companyphone I was just wondering if there is an eas
I was hoping that someone knows a formula for what I want to do. I want to have the F&B per group room night (Budget) to calculate based on the room nights (Row 8) multiplied by the F&B budget (Row 9). but the kicker is that I need a formula that
Is there a way in Excel to have the same data in two places such that if data is updated in one location the other will be updated as well? I know how to setup a link but that data only updates in one direction, I would like the update to go both way
I have a excel sheet like this, is there a way to get value in C8 using C6 in VBA? ! --------------Solutions------------- A non VBA method: Name the ranges by the their particulars So, C2 would be x, C3 would be y and ... To do this quickly: Highligh
I want to show a cell value in a cell where it is being referenced to a cell that includes a simple formula e.g. In D4 I want to reference C4 (i.e. =C4) and show it as a value, where C4 has a concatenate formula: =concatenate("000",A4,"-&qu
Is there a way to use a formula for a range of cells with text? I mean that I have two separate Sheets, here is the example to understand: What I need to do, is to make a formula for YES or NO in Sheet 2 Column B if any cell in Sheet1 Column A contai
I am trying to find a formula that works out the business hours between two dates in excel. The business hours start at 09:00 and end at 17:00 and do not include weekends. The spreadsheet is currently laid out in the following way; A1: Start Time - B