horizontally

i know veritfically (ie offset($a$1,0,0,counta(....) but how do you make one horizontally for 2 rows. also, is it possible to make a dynamic range formula that expands BOTH veritically and horizontally?

Hi All, have a question. In C column I have my product serials. I want to look for them in column A and if they have a match I want the City names in D3, E3, F3 etc. So I want them horizontally. Tried to to it with index and match, managed to do one line but then were not able to pull it down...

I have PARTS listed in column A and CUSTOMER NAMES in column C. I need to look up column A and return all customers associated with a PART and display it horizontally. Any help would be greatly appreciated.

Hey guys, so basically I have a list on the left of companys (company a, company b as example) and list of products for each company (P1, P2, P3) and the revenue Now I need something like the right hand side where all the products for each company are in a single cell (or even how to have...

Hello there! Some time ago I found 2 VBA code blocks on the internet that allow me to do the following: * automatically merge all cells with the same value in the active worksheet * automatically unmerge all merged cells in the active worksheet without data loss (the original value of the merge...

Hi all, Here is a way to display long statements in any Excel rows instead of using merged cells. It works perfectly ''horizontally'' Does anyone know how to adapt it ''vertically'' ? It drives me crazy ... :( Here is the link...

Hi everyone, In B3, I have the equation: =AVERAGE(INDIRECT("b"&(today()-$A2+5)):INDIRECT("b"&(today()-$A3+5))) When I drag this equation horizontally the two ["b"}'s stay as b's. What can I do to have the two ["b"}'s change to the new column with everything else in the equation staying...

=SUMIF(B2:B4,B2,F2:J2) Hello All, I ran into an issue using SUMIF. The formula above only pulls the number in F2. I want the SUMIF to sum horizontally, instead of vertically. I thought it would sum horizontally? thanks

Hello everyone! I run the rum - offset - row formula for the values in a column to sum every other 10 rows and when I drag the formula down (vertically) it works. When I drag the formula horizontally it keeps summing only the first 10 rows of the selected area. Any ideas how to make it work...

Suppose I have data in A2, C2, and E2. And in column F2 i want to show that if any of those three separate cells (it is not a range) have duplicate data horizontally (in a row), then show in F2 "duplicate" if not then show "safe". How would I do that efficiently without repetitive formula or...

I have excel data vertical. However, the files I am getting to upload has the data horizontally. Is there a quick and fast way of changing the format to horizontal? Using Excel to transpose it, will take a long time.

Hello all, I have a spreadsheet that has data running horizontally and at the bottom, the function =SUBTOTAL(104,L3:L65) to give me the maximum number in the column of data. This formula was then drug horizontally. I have since wanted to add cells to this, and have entered in the formula...

I have 5 names from G3 to G7, I need to have these 5 names horizontally from G3 to K3

Is use of filter horizontally possible? I want use filter vertical and horizontal in same excel book on different data. Is possible?

Hi good people!, I have googled and found some codes, but they do not work. Why off course, I cannot know. I am looking for vba code which will align 4 graphs, next to each other, horizontally. The first graph must be used as "anchor"..so the remaining 3 graphs must just shift to the left or...

Hi all, Is there a way we can do dates transpose for same values Horizontally . for example if we look at the below table I want dates to organized horizontally in one cell like this (Aug-9-2017, Aug-10-2017 , Aug-11-2017) for the ID 41661 <tbody> </tbody> FacilityID BusDate 41661...

I need some help. I am teaching myself how to code in VBA and still have a lot to learn. I have a big block of data that I am trying to sort. I have been able to sort data vertically in the past by vba code. However, this time I want to sort data horizontally. I know my error is in the section...

I put the default toolbar button to insert a cell on a worksheet. However, I want to insert it horizontally and not vertically. If I use the menu, it gives me the option to change it to horizontally for that instant. But if I use the toolbar button, then it does it vertically automatically. Is...