ref

I have ref numbers in Col A and values in Col B where the debit and credit values match within one row of each other and the ref no. is the same or the ref contains the text Reverse in the aame row as the credit value, then the rows containing these items are to be deletes for eg B2 is 100...

Many time user....first time poster :) I am looking to return a column value from a single row based on two variable (one in rows and one in columns). Hopefully it makes more sense in the table! I have 'over engineered' a solution but hoping for something more streamlined to save workbook bulk...

Hello, The below formula is designed to count the number of columns there are on a different sheet. There is a problem with it though, and that is if I delete a column/row then the ref errors out on me. How do I reference a row/column so even if I delete a row/column within its range it will...

Afternoon all, I am looking for something that will allow me to get a close match using a sort function. It will work like this. There would be an input cell required. There will always be 8 character letters. The character letter database will always be in a random order consisting of P M Z...

Hi Guys, Just wondered if anyone could point me in the right direction, I have a long list of monthly reports on a sheet called “MONTHLY REPORTS DATA” the most recent report at the top and then the second to most recent and so on, all the reports are 15 rows high and 8 columns wide, I have...

Hi! So here is the problem. We get a PDF report, and since it is not that well made, when we extract it into excel All the different columns get put into column one together. We only need a few lines from there that I managed to offset (so some cells in column D are empty) and from these lines...

Hi all, As always thank you in advance for any help! What I would like to do is: Loop through each row in column G using the ref number if column h of the same row isn't blank do nothing otherwise check column c of the same row and if that isn't blank copy and paste that value in the same...

I'm trying to convert this to give me the value in the cell 1 column to the left of this. I tried adding a simple =Offset(ref,0,1) with the ref being the formula below but it won't accept it. =LOOKUP(9.99E+307,1/ISNUMBER(D5:BH5),D5:BH5) Any help is greatly appreciated! TIA!

Hey Everyone! I need to create a macro to make come reports easier to handle. One of them looks like this when it gets put into excel. Basically it tells who the owners are to certain stocks. I need only the rows where it tells the stock owners only. A cell like that looks like this for...

Morning, I have been using some formula i have found on here. =MAX(0,1+MIN(EOMONTH(F$1,0),$C2)-MAX(F$1,$B2)) But when i put it into my table it adds the numbers from the previous month: <tbody> A B C F G Ref start end 01/01/2017 01/02/2017 548782 04/01/2017 05/01/2017 2 2 563762...

As per the question, i have two columns, one entitled 'ref no' and another entitled 'qtr'. There are about 400 rows in the sheet, with multiple ref numbers. What I want to do is revert to a value of 'Q1' in the 'qtr' column every time the 'ref no' column value changes. (text in red) How can...

I am trying to work out a way of doing a lookup whereby the formula/VBA returns a value for a given reference on sheet 1 if one or a combination of values with that reference on sheet 2 add up to a defined value with that reference on sheet 1. By way of example: <tbody> Sheet one Sheet two...

Hi, I have a problem which I cant solve, will do my best to explain. I think I need something called an index match formula? but I cant get it to work. I have two excel spreadsheet tabs. Tab 1 contains the data I want to extract, tab 2 will contain the formula The table below is an extract of...

Hi team, I'm having random issues with lookup, hopefully I'm doing it right, but for some reason I'm getting an "N" value for a lookup that should be returning "Network". It works for most of the other cells bar a few. Basically i have a ref table on Sheet2 with Keywords (services) and...

Hi, I have a financial plan that i am working on, unfortunately i am stuck with a REF! error. https://imgur.com/a/uDLJU https://imgur.com/Pn3bE8r Here are some images, can someone try and help me out with this. Thank you in advance

Hi, can anyone help with a macro? I have Data on sheet1 - AJ2 has the row Ref and AK2:AQ for the Data and column AS to add 1 for every row used. I have two buttons on sheet2 I want to use as a Plus and Minus (E1 as Minus and F1 as Plus) I want to click the Plus button to add 1 to next row in...

Dear all, I am trying to find a formula that will return a value in the "Value" column in the small table to the right of the larger table. i.e next to cat 1 ref 129 should have a value of 182,500? Can anyone help? Thanks Chris <tbody> Cat 1 Cat 1 Cat 1 Cat 2 Cat 2 Cat 2 Cat 3...

Hi can anyone help with a macro that I could use with a drop down list that will find and select rows based on Name from column A and the Ref from column C (Sheet7) IE if I wanted to find 1 as the name from column A and 10 as the Ref in column C in this example A14:J16 would be selected or if I...

Hi can anyone help with a formula or macro? I have Data in columns A,B,C and have created a table E1:G10 where I want to find the last ranges used in Column B for each name in Column A using Column C as the Reference. ie <colgroup><col style="width:48pt" width="64" span="5"> <col...

Sub test() ' ' ' Record macro gives me this: ActiveCell.FormulaR1C1 = "='Sheet1'!R[-45]C[8]" ' I want the actual cell it is getting...like this...but this doesn't work. ActiveCell.Formula = "='Sheet1'!I3" ' This is what I want but it doesn't work ? End Sub