version

=IF(F3>=90,”A”,IF(F3>=80,”B”,IF(F3>=70,”C”,IF(F3>=60,”D”,”F”)))) Keep getting #NAME? Error Trying to compute a letter grade score from the number grades listed in column F Any help, even an alternate formula, would be appreciated

Hi guys, So I found this thread from a while ago (2008) https://www.mrexcel.com/forum/excel-questions/361577-wait-till-workbook-opens-calculates.html and the idea behind it is exactly what I want, for my code to wait until the workbook is open. In my case (and maybe just because this was used...

I have a file that I update pretty much everyday. Today, I was reviewing the file and all looked good and I made no changes. I have auto save turned on. Later this evening, I went back to look at the file and excel attempts to open it by I get an error that says “Sorry, something went wrong...

Hi All, I just need a VBA code to Change Pivot Cache. this code should work with any type of excel Version Thanks Nasmin

I created a series of IF statements in Excel 365 that include VLOOKUP statements. In the Excel 365 version I nested 10 IF statements together and the formula works. When I tried to save the file as an Excel 97-2003 version the formula was erased. In this older version, I think the maximum IF...

Hi team, where do i get Datedif formula, in which version of excel?

Not sure where to start with this...I have the "desktop" version 1903, build 11425.20244 of Excel installed on 2 Dell Inspiron laptops running Windows 10. The laptops are the same model but one is the current year & the other the previous year. The problem is that Excel looks different on the...

Hello! I was given a user "form" (an Excel Sheet with cells designated to enter info) and tasked to be able to "push" the data from the "FORM" page to the "Upload" Page. The form has two basic versions - one where all of the cells are have direct correlations to the Upload sheet, and another...

Hi folks, OK, got myself in a jam again. :confused: In a major re-building of my project (to make use of stuff I learned here :)), I did a lot of copy/pasting procedures from the old version to the new. Obviously I did something wrong, because the new version keeps calling up (or trying to...

I'm running a project right now that has grown beyond what it was ever intended too. This is an Excel VBA application used within a single dept. Every user should be opening the file from a single location and always be running the latest version, this however isn't happening. What I'm...

How can I tell -- by talking to someone over the phone -- if they have a local install of Excel? I've sent 2 people a macro file and the macros don't work. I believe they're using the online version, but I don't know REALLY how to tell (save a copy seems to be one way?). And then, I helped one...

Hi all, I have a list of Suburbs, and a list of street names. I want to identify where someone uses a lower case version of these. Basically I want to say, if you find an item within the string that is in the named range, let me know if it is the lowercase version...

Hello,</SPAN></SPAN> Data column "C" and columns D:F got results what I want copy all results of columns D:F and put them together in the columns H:I as shown in the example below</SPAN></SPAN>...

I am using the new Excel formula " TEXTJOIN" and works great however this formula only works on the new version of office 360. What formula can I replace this with on older version of Excel? Does anyone know? Thanks in advance. {=TEXTJOIN(",",0,IF(J20:J23>0,H20:H23,""))}

I think I may have to create and Access program for 2007. The problem is I have 2013. It's pretty standard stuff but I'm not sure if it will run on such an old version. The Excel stuff I've done works fine. So, am I outa luck or will it still work?

What is the Teradata connection string when connecting in VBA code? I understand that the provider now includes the version number.

Hello I have 2 sheets in my workbook. Basically it is an external and internal version of the same content. All information on the external sheet is linked by formula to the corrosponding internal version. So in A1 on external version is a formula linking to A1 on external version. Both cells...

Hello, What Microsoft Office version has the UNIQUE function present? Because I have the latest version of Excel 2016 an that function is not preset, why ? Thank you.

Apparently, the technology for sending emails from Excel vba is in a state of flux, particularly, when you consider that the syntax seems to be different for each version of Excel or each version of your operating system. Does anyone know of a simple approach for Excel 360, 64 bit and windows...

Greetings all, I have an issue with Excel in Office 365. My company just upgraded from Excel 2013 to Office 365 (Excel 2016). Now I am having issues with macros. My form has an email function built in that is ran by clicking on a button. The email is sent to a different organization when...