told

Hi All, Good Day! I want to know how to connect to Oracle DB without oracle installed on the system. When check in google it was told to use Oracle.DataAccess.dll. But could not do that can any one suggest how to use this dll and connect to oracle db. Using VBA macro. TIA

Hello, I pulled a lot of data, and I need to mark which one is the most current. Is there a formula I can use to do this? Someone told me I might need to use an array formula. Essentially I am trying to get a formula that will print the text in yellow in the picture. https://imgur.com/a/RDJYrSO

Hi I am trying to help my son with his assignment and he has been told to get his sheet to show blank in this array formula returns a value of #N/A {=VLOOKUP("N4",CHOOSE({1,2},Table1[[#All],[Seat Number]],Table1[[#All],[Ticket Number]]),2,FALSE)} I have tried using If(ISNA) in the array and I...

Hello again In the past I've had (and my co-workers, too) a weird problem where we'll go to use a macro and our entire Personal Macro Workbook is just gone! It's been VERY rare and I was told how to fix it: Open a blank sheet, click "record macro", Select for it to go into Personal Macro...

Hi, can anyone tell me the correct way to use dates in a Excel Spreadsheet - I have been entering dates like this : 27/01/2018 which I am told is incorrect. Many thanks

? Format("06 Jan 1990", "mm/dd/yyyy") 01 06 1990 Why does it not result in 01/06/1990 like its being told to ?? Using Excel 2007. Thanks.