invert

Hi, I need to invert text in cells up down side and I have found the best way to insert textbox and invert it then linking it to the cell. I try to make the text in the textbox to shrink to fit the size of the text box, thanks in advance.

How can i invert the text of a cell?? Thanx Brian

Hi All, basically I have managed to get "Drop nr" or let say unique rank by ID" in order" column but trying to get in reverse order "new drop a to z" instead. Colum D is showing what I want to achieve, Column B has following array formula...

Hello, I have a simple formula, p = (a+b)^n - b^n, but need to find n in terms of a, b and p. Problem is there isn't an exact algebraic solution (at least not according to WolframAlpha), so I need to create a fully automatic user defined function (UDF) that effectively acts a bit like goal...

Hi, I've modelled myself into a cul-de-sac so I'm hoping someone has an easy solution! The data is accounting data, and so credit values are interfaced as negatives, and debits as positives. I'm using sparklines to show the sales and ebitda trends over several years for a number of sites, but...

Hello everyone, I couldn't find enywhere online answer to my question - how to format cell in a way that, whenever number of characters exceeds i.e. 360, it shows only last 360 characters of given cell. I want full content to be seen only after double click or after extending hight of the cell...

I have a table of values that are computed using input values from the first column (y's) and first row (x's). Each value in the table (z's) has a unique set of x and y. In order to plot z vs x and z vs y I need to create a list of unique x,z and another of y,z. My question is how most...