adjacent

I have this table of the range B2:J6 And I am looking for a way to randomly distribute the letters A-I across. These are the rules: 1. A row can take just A or A and A . If 2 As, then they should be immediately adjacent each other. Example B2C2. 2. The first four letters can appear more...

Im at a loss.. I need to sum values in a column if its greater than the value in an adjacent cell, also if another adjacent cell equals X, and value in adjacent cell equals Y. Typically, the operators in a sumif would evaluate based on a specific threshold.. Ie. =Sumifs(A1:A10, A1:A10...

Hopefully the title wasn't too confusing. I have a workbook with two sheets. On one sheet I have a column for comments and an adjacent column with a list value of "Y" or "N". Then I have another sheet and on that sheet I would like to have a column that contains the comments from the other...

Hi, I am trying to set up a formula which will sum the numbers in one column that meet the following criteria in two other columns: a particular month (in one adjacent column) and greater than or equal to +0.5 (in a second adjacent column). I've put the following formula in but can't get it to...

Good day, I have been struggling to calculate the below. What I would like to calculate is if T is blank or 0 and A is equal 1. I need to know the sum. I have been trying with Sumif, sumproduct and countif without success. in the below example the answer should be 3. Any help will greatly be...

Hi, I have found several solutions in here on how to count the highest number of consecutive blank cells in a single row, like so; =LARGE(FREQUENCY(IF(A10:N10<>"","",COLUMN(A10:N10)),IF(A10:N10="","",COLUMN(A10:N10))),1) This works like a charm. However, how do I go about counting the...

Hi , I know how to use the Simple IF and IFS formula. I am trying to combine two , three IF formulas based on a set criteria but there is an error in my formula. Could you please help me. Thank you What I would like my formula to do is search for two conditions in two adjacent cells, if...

Hi, I have text in a single excel cell which looks like this: * Apple: some general text. * Pear: more text. * Orange:some more text. I need to extract the each instance of the strings between the characters * and :, and put them in separate, adjacent cells. e.g. <tbody> A1 B1 C1 D1...

Hi guys, I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty...

Hi all,The code below sorts the figures out in each block of rows then places the position of that figure in the adjacent column,like this where the smallest number is 1 second smallest 2 and so on. CI CJ 1 24 2 26 3 29 4 34 5 35 6 37 <code>Sub rankandSort()...

Hi Everyone, I am pretty new to Excel and VB (got some basics :) ). I was wondering if someone can help. So I have a column G containing cells of different values(times); some of those cells are blank. I also have an adjacent column F that doesn't have any blank values (all filled with time...

Assuming the data below starts in column A. I'm trying to write a formula in rows 1-3 that will look in Column D, find the top 3 in rank, then provide the adjacent from in columns A,B,C,E, and F. Help? <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Tiger...

Hi, I wasn't exactly sure how to title this. The idea is that I have a column of names on Sheets("DateAssigned") that are pulled from a list on Sheets("Tracker") using INDEX, and that list from Tracker is auto-filtered alphabetically. In the columns adjacent to the column of names on...

Good day All, Hope all is well. May I ask if it is possible to get the adjacent value in column A based on the given cell reference number? For example: A25: Dog A26: Cat If cell G1 = C25, then return the value ‘Dog’. And if cell G1 = D26, then return the value ‘Cat’. I would greatly...

I tried to use formula below to sum cell values in a given range by a given criteria. =SUM(IF(Asheet!I:I="Y";Asheet!F:F;0)) It should values from F, where values in I are Y.

Hi. I have this formula in my Excel spreadsheet: =MIN(C4,K4,S4,AA4) It gives me the minimum time value from each race, as the running event is comprised of 4 sub events of which your best time counts. I would like to know, how do I get my spreadsheet to display the adjacent cells to the left...

Hello. I am looking for VBA solution to loop through column A and to enter formula =Today() in all blank cells in range A2:A1000 if adjacent cell in column B is not empty. For example in table below formula would need to be inserted in cells A3;A7, because they are blank and adjacent cells...

Need assist If value in Column T is found in Column H copy value adjacent to Column Z range A1

Hi Can board members please assist me. I have a cell, if the 7th character from the left = "i" I want to return the value "Yes" in the adjacent cell. I can't quite work out the if formula Many thanks

Hi there, New to VBA - have tried a few different bits of code but can't find one that achieves what I need. Trying to transfer a 2-axis dataset into stacked columns, removing zero balances. I want to populate adjacent columns with the headers along each axis. Below / linked image is an...