multiple columns

Hi Folks, I've had great luck with the members of this site, so here goes... I have a data sheet where 12 columns contain a dynamic number of rows/cells where some are formulas and some are hardcoded values. This file is submitted each month. I would like a macro to insert the "Round"...

Hi I hope you can help. I'm trying to highlight a range of cells that fall between a range (>41) but only if the time in the adjacent column falls between two times. The sheet shows tidal ranges and I want it to highlight tide values above 41 (column B) but only between the hours of 09:00 and...

Hi. I am new to posting so hopefully I do this right. I can't figure out how to attach my file so I pasted part of it below the code. :rolleyes: I changed the actual text (I'm not working on animals) :laugh: Background: I have a template my team uses but the conditional formatting does not...

Hi, I found codes by some expert here on regards to select the filtered rows excluding the headers:- Dim aRng As Range ActiveSheet.Range("$B$4:$U$" & Rows.Count).AutoFilter Field:=20, Criteria1:="Jan" Set aRng =...

I would like to sum within range all values that match a single column criteria for the sum row along with multiple columns that will indicate which specific cells within the row to sum. My formula...

Hello, I can't seem to create a correct formula for in cases where summing column D "sales target" of only "Division A" (Column A) if Value in column C is greater than value in Column B This didn't work =SUMIFS(D3:D60,A3:A160,"A",C3:C160,">B3:B160,B3") Please help! <tbody> <tbody>...

I have data that I need to sum together and then use a vlookup to assign to an individual. I have been trying to use SUMIFS to use a double criteria, but it hasn't been working. Any ideas? I want to be able to use a formula to pull and summarize the data below as follows <tbody> Cost A...

I am trying to find out how long (in days) a ship is spending at a specific location by analysing satellite data. This would be easy if the ship gave out consistent data, but due to technical issues it gives out inconsistent signals giving incorrect results. The satellite data also gives time...

This is my first post and I’m aware it’s a bit of a long one. Sorry! I'm looking to use a sumifs formula (which I have working on a single column) over a range. I've searched extensively online, but can't seem to find a way to do what I want to do - maybe a search terms thing?!?!? I have an...

I'm trying to find a workaround for the fact that Quickbooks does not have a suitable solution for printing donation receipts that comply with Canada's CRA guidelines. We are not actually using Quickbooks yet, but we need a more formal system, and this seems to be the preferred option, with the...

HI everyone I need to search two columns for a text string, and return a 'yes' or 'no'. The challenge I have is that the data is entered by a number of different people and they use a combination of lower and uppercase letters. Currently I have this (thanks to a little worki on Google)...

Hi, I'm struggling to write a formula to sum the values in column A based on a number of conditions, including one that applies over multiple columns. Using the following example, I would need to add the values in column A if condition 1 = Australia and the value in at least one of the areas...

If anyone can help me I would be very gratefull. I am looking to create a formula that will create a unique list of names, in a different location that considers 6 columns worth of data as well as the how frequent each name occurs. Here is an example of what Im working with...

Hi I am working on an annual planner and want to get dates to autofill in required cells (this bit works) the issue i am having is in compiling/merging the information for these lists. I have found ways of doing it for one column however i want to copy over the three columns from each range (I...

Hi, I'm Beginner of VBA, pls help me create the VBA for VLOOKUP for following data. I've Book1 having 2 sheets. Sheet1 having the raw data, I want to create VLOOKUP in sheet2 to culled out the data from sheet1. Sheet1 A B C D E F...

Hi there, I have recently started to maintain a spreadsheet at work that carries caseloads. I've been using conditional formatting and a few other formulas to make it more accurate and easier to maintain. I've had to do a lot of searching to find the info I've used so far, but I can't seem to...

Hi All, So I've been stuck on this for a long time and will hugely appreciate any help given. Basically: I have a Userform with 6 List Boxes on it. Let's call them: Group1 Group2 Group3 Group4 Group5 and TempGroup Each Group (1-5) is populated with a 2 column list from range on the...

I have searched extensively, but have not found a solution to fit my specific need so it is time to ask for help. I have a worksheet that contains multiple task lists, each having two columns, a "Priority" field and a "Description" field. The data should be sorted by Priority first and by...

Hi all, I am new to this forum, and really need help with the following task: 1) I have a list of of random numbers in column A 2) I have a second list of random numbers in column B 3) Would like to find the mode of column B for each unique number in column A For example: Column A...

Hello, I'm trying to write a SUMIFS formula where the range for the first piece of criteria spans multiple columns as shown in the example formula below: =SUMIFS(Sheet2!N:N,Sheet2!O:Z,Sheet1!A3) So the value in A3 on Sheet1 can appear in any column between O and Z in Sheet2 over multiple...