excel & formula

Hello, I'm a very new (I mean literally an hour) in using VBA and Macros and I'm trying to write my very first if statement. The issue is that when I try on a single cell everything is fine, but I am trying to apply it to the whole column! More specifically - if something occurs in column A then...

Hi Everyone, I am short some correct code to finalize this sheets for customer ageing This is the sheet with full data of invoices ABCDEFGHIJ6OUTSTANDING INVOICESREPORT DATE:5 Sep 202478DATETYPECUSTOMER NAMEINVOICEAMOUNTVATDUE DATEDAYS DUESALESPERSON91014/09/2022InvoiceMy Skin...

Hi Everyone, I am trying to pull out list of my cheque deposits based on date it has been deposited, i have full list of deposits but i want only list based on the date i have provided on Daily Cheques Deposit sheet. Since, we deposit multiple cheques in same date so, i am unable to pull out...

How to compare Workbook2 to Workbook 1, After match to show Statment "Yes","No" on workbook 1 We need to match Product / Description / HSN code /Qty / Rate/ Tex(%) from Workbook 2 , i can't know how to compare workbook and so if statment in Workbook 1 [ i Column ]

Hello everyone, I'm working with an online educational platform that caters to UPSC students, and we're trying to enhance how we provide current affairs data. Our goal is to automatically populate an Excel sheet with the title, publishing date, and link of each current affairs post from both...

Hi All, Really need your help as I am pulling my hair out on how to do this! Basically I have a column (F) which is has a date in for 'Date Response Required By' , and column (I) has 'Impact against programme'. Column 'I' has the formula input into the cells to work out the programme...

See attached picture for the detail: Question: The output for column D, E, F should be using the number in column C * % starting from 100% all the way down to year of 21; however, the installed number in column C can happened in year 5,6, or any year, how to make the calculation in column D...

Hi Experts, I am trying to make an interactive sheet that would create a key using specific data to then use as an identifier across multiple sheets. As information is subject to change, I want to add 3 input columns that would essentially: 1. If all cells are blank just uses the same value in...

I'm looking for a excel formula that will provide average sales before and after a date when a facility was closed. In column A I have the facility location #, and in the row going across I have weekly sales data from 2022 to 2024: During the time of 1/10/2023 to 2/10/2023 the facility was...

Hi, I need help to create an excel formula. I need to increment the reference column if the vendor and date changed. ORIGINAL RefNumber APAccount Vendor TxnDate LineAmount 2000 QGiv 1/1/2021 39.48 EFT-01/01/2021 2000 QGiv 1/1/2021 39.48 EFT-01/01/2021 2000 QGiv 1/1/2021...

Hey! I want to add formulas to various cells in excel with VBA , the first two work really well , but in the third (bicipital) I always get a error saying that there is an error with the formula I have tried copying and pasting the first line that works and changing the name , still doesn't wort...

Hey I need help on this: I first solved the proplem of showing the correct cities based on the what was selected in the first drop menu by using this formulas in data validation: (coutry and city are named ranges for countries and cities). IF($E$3="US",OFFSET(city, 0, 0, 2, 1),city) But the...

Hello, Can anyone help me make an automated Excel spreadsheet to calculate the interest on every month's contributions? The compound interest is calculated once at the end of the financial year by taking the monthly contributions. Here the only input value is Basic (I column) and the Interest...

I am trying to write a formula where the PO Quantity will look at the MOQ first the round up by the pallet quantity to get my desired order quantity. As of now it is rounding higher by the MOQ, so in the example below it is suggesting 6,000 however I only need the MOQ of 3,000 + an extra pallet...

Hello, could anyone help to find out why the formulas to show the "No Data" numbers not working? These are the cells: AD11-AO11, AD26-AP26, AD37-AP37 It was working fine, but when I have added some columns it stopped. I tried everything but coudn't figure it out. In the sheet I need to know...

I have 2 workbooks. I use one workbook to track issues that I have input on the other workbook. i.e. on the current workbook, I need to search the second workbook for a value offset by -3 from the current workbooks activecell. I need to take that text value found on the second workbook and...

Sorry I don't have a copy to post just now but looking for help for the following if possible if not I'll try get a post up with table, I have a few sheets taking data to my last sheet, IE (A4) Spoons needed (B4) 6 (A5) Plates needed (B5) 10 (A6) Cups needed (B6) 0 And so on, what I am doing...

we have the following data which we want to sort with serial 1. Samsung1. Samsung2. Sony2. Sony2. Sony4. Dell4. Dell4. Dell10. TVVS10. TVVS20. JBBL20. JBBL20. JBBL20. JBBL result sheet 1. Samsung2. Sony4. Dell10. TVVS20. JBBL help with formula please

Hiya, I have a workbook that I drop data into on a daily basis and I've got an issue getting a count to work for a time column. The column is just times, C:C, in order but they change thought the day depending on the workload done. So for instance right now the times range from 13:15 past...

I have a spreadsheet with dates in see below - column M is the difference between G and F - if G is Blank then it returns a blank in M - what I want is for the value in column u to show a 1 if the the value in column n is more than 100 - at the moment it also returns a 1 if the value is blank...