missing

Hi I have this workbook that is supposed to compare data in columns B-F against data in columns I-L and if missing from columns I-L it supposed to say MISSING in affected row in column G. It then supposed to look in columns I-L for duplicated entries and then if duplicated it marks one of the...

I have a spreadsheet of store numbers that I need to change around. The first 3 characters are always ABC, and then it follows with 2-4 digits. I need to make these all 4 digits, with the missing characters being made 0. So for example ABC1234 would stay as is, ABC123 would become ABC0123, and...

Hello, When I apply a filter to this document I'm using, a lot of the data suddenly goes missing. I've got a lot of two digit codes that I'm sorting by and when I sort A to Z it only brings in the codes that are numbers and remains blank for all the other two digit codes that have letters...

Hi all, first post here. I've been learning VBA, and I've found the best way for me is to jump into exercises I've never done before. I recently came across a problem and decided to take a shot at it. I'm trying to use VBA to solve for the equation A = (B/C)^D, where any one variable A, B, C...

What i am trying to do is we have multiple accounts and products, would like to find the missing products for each account. I saw solutions for matching one set but not multiples Account Product 1 Apple 1 Orange 1 Tomato 2 Orange 2...

Hi all, I am using this code right here ActiveCell.FormulaR1C1 = "=IF(RC[-1]="",IF([-35]<>"",RC[-35],"Misc"),RC[-1]" Whenever I go to another line I get an error message that says "Expected:end of statement". I do not know why this keeps happening. It is probably something simple I am just...

Hi If I type "=-85.00" into a field in excel I get #FIELD ! If I type this on my other computer I get -85 I presume there is a setting I am missing Any help would be appreciated. John

I have data that looks like that: <colgroup><col span="2"></colgroup><tbody> a 1 b 5 c 3 d 7 e 2 f 2 g h i j </tbody> I want to fill the missing data in column b. that will be paralel to column a. I wrote the attached macro Range("B1").Select...

Hi, I have data in column D, and data in column E. I want to move this to column F (for printing) so that it runs D1 E1 D2 E2 D3 E3 Etc. I can pull the data D1 into F1, and E1 into F2, but when copying down, it does it like so: D1 E1 D3 E3 D5 E5 Is it possible to have it so that the...

I am trying to make the following work in Excel, not VBA. =INDEX('[&A2&.xlsm]&B2&'!$B:$G,5,1) I know I am missing string quotations, but am unsure what else is missing. Does anyone have any input here?

Some Helpful advice please. Imagine a collection of 10 items (First to Tenth) each item comes in one of 10 possible colours. So to collect them all I need all 100. Now I can create a table with the numbers as column titles and the colours as the row title which would allow me to tick off as I...

I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar. Help is appreciated. I tried CRTL+F1 but all I get is a help screen. Thanks,

I have a table with several columns. The first is a name and the second is a date. For each name there are several dates. The dates should be sequential. If there is a gap of one or more days, I would like to add a line with the name and the missing date. <tbody> david 3/5/19 david 3/6/19...

Hi fellows I would like to know the missing day between the range that exclude weekends(Saturday, Sunday) in the following example from the date range A1 to A4 what is the formula we have to write in B2 and B4 to get result like this? <tbody> 2019/06/05 Missing Days with out week end...

I am trying to setup a spreadsheet to track a number of values. I only need to create a running total when the total of 2 columns becomes a positive value and then track it back down to when it moves back to a negative. The data looks like this: <tbody> Value A Value B A + B Required Result...

I have a query that's connected to a file that's supposed to automatically every day. Today, for some reason (not my issue), the file wasn't there, but my query didn't tell me the file was missing. Can I flag the query so that if the file is missing it alerts me? Thank you! Judi

New to Power Bi, first report. Not sure what I did, but had two named report tabs on the bottom. Now it just says "Page 1 of 2" with no tabs. Any help with getting back the tabs would be much appreciated!

I was sent a workbook from one of our suppliers and asked to complete it (its a questionnaire.) Whenever someone tries to choose a selction from one of the drop-down boxes on the worksheet (not in a form) we get the 'user-defined type not defined' compile error... same thing happens on any...

hate last minute change requests, but The code works fine on the worksheet where the data resides, see below <code>=SUMPRODUCT((I3:I51="S")*(J3:M51=2))</code> but won't work when code is on another worksheet <code>=SUMPRODUCT((Entries!I3:I51="S")*(Entries!J3:M51=2))</code> what am I...

I've been working for sometime on creating an accurate payroll environment within excel, and I'm finally close, but ran into an issue I could use the expertise of this forum with. The workbook contains sheets for each month (January to December) separated by Quarterly sheets that populate from...