formulas and functions

Hi, Need to count any numbers from a 2D array if it is standalone in a horizontal row - formula needs to work for whatever column its in Ex: COLUMN A COLUMN B COLUMN C COLUMN D 25 94 83 92 78 32 56...

Hi, I have an array full of prices and 1 date column. I need to display the most recent value of each row's array that are all equal to today's date. I plan to sum all the numbers eventually. Ex: TODAY'S DATE: July 4th 2024 04-Jul $14.00 $45.00 78.00 18-May $63.00 $86.00 $92.00...

I'm trying to find "matches" (loosely speaking...) in a 3 column table and displaying the results in a 4th column. Column A is the driver, and can hold up to 5 pre-defined values, or any COMBINATION of the 5 values. Columns B and C cannot hold any of the values found in Column A, and again, can...

I am enquiring if there is a function, or formula, or VBA that will allow me to create duplicate rows based on cells with unique values. e.g. The below is a small sample of the data I need to create duplicate rows for: I am hoping there is a formula, or function, or VBA etc. that will...

Hello, I have a spreadsheet with many rows and I need to move specific articles (red articles) from the column A to the column C so that their cells still blanc in column A, can someone help with that? ABC1article 12article 23article 34article 45article 56article 67article 78article 89article...

I have 2 Tables of which Table1 contains the full data pulled from the required sources and the following is the format of that how it looks: For Table1, all the details of the Volumes and Errors of the respective Sub-functions & Team Members will be pulled automatically through a macro...

Hello friends, I have a worksheet that has my stock transactions. In column D, I have the # of shares bought with the cells formatted as a Number, and, in column F with the cells formatted as Accounting, where I have the total purchase cost for the date of the purchase for those shares. I want...

Need excel to automaticaly bring data from a table .. help please

Hi, what formula or approach would you suggest to do the following: You have a travel tour with the starting date from 26/02/2020 - 15/04/2020 is there a way to split the income for example : 1st split is from 26/02/2020 - 29/02/2020 2nd Split is from 01/03/2020 - 31/02/2020 3rd split is from...

I have a bit of an odd workbook (I know, that's not unusual here :) ). There are two sheets: the second is the data page, the first is a search of sorts for the data on the second. The search allows the end users (and I'm trying to allow for those who barely know Excel) to type in a phone...

I can't seem to get this to work =IF(ISNUMBER(SEARCH("Rejected",A2)) =IF(isblank,"","Today")) Any help would be appreciated. Dorinda

I was in a situation where I had to do some conditional formatting for cells that had invalid entries relative to validation rules. As far as I know there's no formula that checks validity, so I started a thread on the official Excel threads, and I talked a bit about it on twitter, but have...

I'm looking for a simple excel formula that will populate a cell with the date and time when the file is opened. I appreciate the feedback. Brian

I have a payroll workbook that has 26 payroll worksheets and an OT Totals worksheet at the end. I'm trying to figure out a formula in the OT Totals worksheet that will find an employee's last name in each worksheet and total their Reg OT. Last year I just made a formula by going to each...

Hi all, I am wondering if something is possible at all. I have a calendar on Excel (month-by-month) and then another sheet with all the dates of all the different events that are happening. I want to be able to click on a date in the calendar and then below, a list of the events that are...