bit

Apologies in advance if I don't articulate this clearly. I'm not sure I understand myself exactly how to say describe it. I have 3 tables, one in each column (A-C below) I am using Power Query to do a cross join (or cartesian join - not sure the right name) and the output of that cross-join is...

Hi, I wonder if someone can help me. I need to know how over due something is based on TODAY() from say column K but, to ignore this if, column R is populated. I've got the first bit sorted ok, it's the second part that I'm having trouble with. My formula is below, I cant work in the...

Hi, I keep getting an #ref error when trying to populate the left matrix with data from the right table (located on another worksheet). I am using the following in b2:=index(j:j,match(b1,h:h,0),match(a2,i:i,0)) and that yields the #ref error. Any advice? Excel 2016 (Windows) 32 bit...

(Why is my forum tools add on making the data look like this? Am I using an old version?) This is even mission critical, I just want to do it on my invoices because it can be done. I currently just manually add 30 days to the invoice date, then use the last four digits of the customers...

I just found out that I would have uninstall my 64 bit Windows Office 16 with the 32 bit version because one of the databases we have was written in the 32 bit version. Will my Excel 64 bit files open in the 32 bit application without losing any functionality? I have some formulas in some...

Hi - I am trying to come up with a formula for R15. The variables I know are P15 and Q15. P15 will refer to the values in column D and I need to find values in the columns where Q15 falls between, so, in this case, we'd be looking at column H. 621 is less than 650, but greater than 600. I've...

hi & good evening. i have a worksheet that on a weekly basis needs the tab changed but will always have the same text after it IE This bit changes weekly-This bit never changes This bit changes weekly would use the info in cell D1 very much appreciate your help. KR Trevor3007

Hi, sort of recurrent topic, but I would need some help regarding this case. Because I work with a third party tool that pulls out different reports to be later processed in excel, I'm a bit stuck since they have run a recent update in which they have changed the date format. Before it was...

You guys have improved my excel knowledge by leaps and bounds, but I need a little help! :) My wife brought me this question tonight and I feel like this would be a nested match formula but I'm failing to make it work. For some reason "Forum Tools" isn't working nicely with Excel 2016 for...

Hi everyone, I'm new to vba so please bear with me ? I'm using office 2016, 64 bit on win10 and have used code from online to create a function in excel to count coloured cells. This works fine using 2016, 64bit win10 and 2010, 64 bit win7 however it does not work on 2010 32 bit win7. Any...

How do I ignore the blank cells in this small range of five cells? I'm trying to sum the first three numbers in each cell. =SUMPRODUCT(--(A2:A6<>""),LEFT(A2:A6,3)) Excel 2016 (Windows) 64 bit A 2128/76 3 4118/76 5 6130/83 Sheet: BP

My apologies if this has been covered. I have been looking up and down and cannot seem to find what I am looking for. I am trying to scrape data from an internal website that we have. This data can be retrieved by being copy and pasted, but that is a bit excessive. I recall someone...

I obtained a spreadsheet that apparently was developed on a 32 bit Windows system and I'm getting an error when I try to use it. I'm not familiar with this type of system conversion and I'd appreciate someone's help. The error seems to be on a function declaration. See the attached error.

Hi, I am running the following software: Windows 7 (64 bit) Excel 2013 (32 bit) Access 2016 (32 bit) When I use the following VBA code to connect Excel 2013 to my Access 2016 database, Excel immediately crashes: ---- begin ---- Dim objConn As ADODB.Connection Dim strDBConnection As...

I have a macro I wrote in Excel 2010. We have upgraded to Excel 2016. Now the same macro sometimes works, other times, I get the message that Excel has stopped working. I am running Windows 7 64 bit. Excel (both 2010 and 2016 are 32 bit). The macro sits on a network drive and is executed from...

I am looking for vba code to browse for a folder. Does anyone have existing code that they could share that will do this? 64 bit compatable

Hi there can someone help. I have a sheet where I want on a worksheet change event to..... 1) convert a range of cells to uppercase 2) allow the entry in a different range of cells of time in the format hhmm (without the colon) this is what I have now but here is the problem I can only get...

Hi, I have 2 workbooks linked on the server: workbook 2 has a vlookup formula with the table array in workbook 1. When I open workbook 2, I have a value error cell, even if workbook 1 is opened. If I manually close workbook 1 and reopen it, I have the right value. If I do it with a macro, I...

Hello, I am trying to stay out of VBA. Just want to return the last bit of text.. firstbit\secondbit\lastbit delimiters will always be \ but could be many. Just need that last bit after the last \. Thanks in advance!

hi all. I'm wanting to create my own formula function, but not too sure where to begin.. basic; =WhichState(A1) <tbody> 3931 VIC 4000 QLD 6000 WA 2011 NSW </tbody> at the moment i'm using a =left, plus a vlookup and its a bit messy, and it gets used in a ton of my spreadsheets.. any...