software

I've linked 1 excel file to another. Some fields in origin file are empty,
in linked file they show as a '0'. How do I lose the '0'?

Lets say I have a file that is on a shared drive that multiple users use. The
file is not saved as a shared workbook. The file is password protected and

I have a long list of numbers that ranges from 680,608.60 to 131.06.
I need to sum only those within 50,001 and 200,000.

For example:

Hi
Can anyone assist

I am seeking a profitability model to price commercial loans.

hi...

I am confused and trying to understand the quot;FileExistsquot; function.
I'm trying to check if a file exists or not.Syntax

We need to list times in 'minutes' and 'seconds' as recorded on a stopwatch
and then have excel perform simple calculations such as SUM or AVERAGE.

I have the formula below, which takes the date from a cell(G8) and finds

Hi,
is there a way to automatically fill in the blank cells between two numbers

is there a method in excel where I can convert a row of entires into a

I've configured the clipboard to appear only when I press Ctrl c twice.
Can I close the clipboard with a keyboard shortcut?

It reappears if I close the file and reopen. It's a simple spreadsheet of
300 lines and 15 columns. Anyone else experience this? Is there a fix?

I have conducted performance testing and need help in how to make this

I am trying to set up a number of cell that I can input a single digit and
have the cursor move to the next cell.

I have imported a report to excel which contains alot of blank rows, almost
every other row. I want to delete the blank rows so I can use the auto filter

I have a column containing date and time, for example:

I have some data recorded for every day for some subjects.
And the possible recorded value on each day is: 0 or 1 or 2 or 3 or 4 or null.

is there an easy way after conditional formatting to count colored cells,
e.g., say the cond-formating resulted 10 cells in col A that are red and you