diagonal

Good day experts, I need to fetch values from an identified column (DistanceToNext), across numerous csv files into a single worksheet. These csv files are indexed with numbers. The first csv file indexed 001 is to be pasted in first column of the single worksheet. The second csv indexed 002 to...

I am trying to create a printable golf scorecard. I would like to have the cells for holes where the hole handicap, row 2, are equal to or less than the players handicap, column c, to be yellow with a diagonal border, from lower left to upper right, so that the gross and net scores can be...

I have automated reports that spit out sunmary page by representative. Sometimes one of the charts decides to turn the tick description diaganol. Only many of the diagonal descriptions look the same since they start with same loacation name. Is there some vba code that will turn the xaxis...

Using Excel 2000 Hi, I am looking VBA that can count 3 diagonals signs "1X2" if the are same then result = 1, if 2 are same 1 is different then result = 2, if 3 are different then result = 3 Step1-Start looking diagonal "1X2" signs in C6, D7, and E8 Find 1, 1, 2 Result 2 in T9 Step2-Start...

Using Excel 2000 Hi, I need to highlights 3 diagonals weather are they numbers or alphabets In the example below check first column C to find diagonal in the column D & E For example C6 is empty go for C7 if C7 is empty go for C8, Yes find diagonal in C8, D9 & in E10 (in this case as in...

Hi, I have a formula that uses COUNTIF that I'm trying to get to work using a diagonal range of cells (CT2,CU3,CV4,CW5....DI17). Unfortunately I've discovered that COUNTIF wont work with such a range. Even creating a named list for this diagonal range doesn't work with COUNTIF. Here is the...

Hi, I need to be able to split a cell Diagonally in Excel. Each half needs to have it's own formula, and based on the value of the formula needs it's own colour coded conditional formatting. I've looked for different add ins to allow me to do this but thought this forum may be the place to help...

Hello, I am fairly new to writing macros for excel. I have played around with programming in C but that is it. I am wanting to make a macro that reads the value in a cell (C4) and if that value >= 3 then a certain cell lets say (i31) has a diagonal up border. Else nothing. This is the basic...

I am working with an array formula that SUM's on the diagonal.. =(SUM((COLUMN($H$7:$HU$228)-ROW($H$7:$HU$228)=((INDIRECT(H2))-($G$6)))*$H$7:$HU$228)),0) it is part of a matrix i am using and I need to get this formula to work with MEDIAN rather than sum... actually I need this formula to work...

I am stumped on coming up with a dynamic formula that calculates a value based on an increasing number of "sums of products". Specifically, I need to calculate the total number of repeat users based on a "decaying' repeat rate. In other words, I need it to calculate = Sum[...

I am trying to build report to understand projected savings. My data collection template is similar to shown below <TABLE style="WIDTH: 149pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=199><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt...

I am trying to build report to understand projected savings. My data collection template is similar to shown below <TABLE style="WIDTH: 149pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=199><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt...