finally

Afternoon all!! I have a baseball spreadsheet that has been working up until a couple of days ago. Something weird started happening when the 3rd out happens and it goes to the sub "currinning". I get a Run-time 13 error everytime the Call to currinning happens. No matter what type of out...

Hi Folks, I am using a simple VLOOKUP for retrieving a value in another sheet in the same workbook but just keep getting #REF ! error. Think that I overlooked something. The formula is =VLOOKUP(F3,'Precios '!$A$3:$A$83,2,FALSE) And what I am trying to do with this is to search for value...

I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...

Hi All, I am stuck on something very basic....or not... I need to return a value in a cell based on what another cell value is, specifically: A1 contains a Lookup/Array formula which will return either 100,75 or 50 I would like D1 to display 125 if A1 is 100, display 90 if 75 and finally...

Hi, I am looking for a way to create custom part numbers. I have a lot of custom products and the part numbers need to be created when my customer requests pricing. The way I would like to structure the part number is using a fixed abbreviations (CP for custom part) followed by the Julian date...

Hi Guys, i have a HR table that have people's information in it. It has a column that identifies the Manager of the person. Now , of course , there will be managers of mangers and their mangers and so on , and finally the group head at the top. Now, is there a way to retrieve the name of the...

I have two spreadsheets stored in the same folder on OneDrive. Values in Tab1 on Filename1 is referenced by Filename2. Filename2 contains formulae like: =IF(ISBLANK('[Filename1.xlsx]Tab1'!A1),"",('[Filename1.xlsx]Tab1'!A1)) and this produces the desired result. However, when I close and reopen...

I have tried to find some examples on here, but am coming up empty, if any of you have a good idea, please let me know. Unfortunately with the way that excel deals with numbers, I am running into accuracy issues due to rounding errors, so I cannot do linear approximation for a project I am...