I have a column that's supposed to be an address, but somehow got the
company name mixed in at the beginning:
- Jul 16 Mon 2007 20:38
Stripping text before a number (alpha or numeric)
- Jul 16 Mon 2007 20:38
sumproduct
Hello Can anyone help me? The below formula keeps giving me #num as an answer
what am i doning wrong?
- Jul 16 Mon 2007 20:38
Create custom text format?
- Jul 16 Mon 2007 20:38
Offset function with nested match function not finding host ss.
I have an offset function with a nested match function that looks to a
separate spreadsheet. If I have both spreadsheets open, it works fine. If
- Jul 16 Mon 2007 20:38
Countif with range name
- Jul 16 Mon 2007 20:38
Q-q plot in Excel
Hi there,
Just wondering if there's any way you can graph a quantile quantile plot in
- Jul 16 Mon 2007 20:38
How to insert rows after each row of data (800 rows)?
Sub InsertBlankRow()
For r = Cells(Rows.Count, quot;Aquot;).End(xlUp).Row To 2 Step -1
- Jul 16 Mon 2007 20:38
Macro to convert hyperlinks to text
I have lots of hyperlinks in a worksheet, want to convert them all into plain
text. I couldn´t find an automatic way to do this other than with macros,
- Jul 16 Mon 2007 20:38
How can I run a spreasheet over range of input data ?
I have set up a work sheet that takes input data (a number) from a cell, goes
through all kinds of calculations based on other cells, and finally puts out
- Jul 16 Mon 2007 20:38
Graph Question
How do you plot lines etc without using the wizard? I recieve and answer to
a graph question I had that explained how to make the graph I wanted, but the