Search results for query: *

Ken is the man, and I'm hoping this approach flies with the boss. Not sure just how much of the data I need to hold on to, "for posterity". The reason the sheet is so darned disorganized is that the original data file was a plain ascii text file, which I imported into Excel. It has been a...

Sumproduct would be excellent if I needed to sum up all the values. But I need to sum them individually. Is there a way to use individual sumproducts and stop when there is a blank row? The information isn't uniform, IE, the first set might have 10 rows, the next 30, the next 12.

I'm trying to sum the number of items. The number +XX is the value of the items, the next number is the number of items, the next number after that is the total value of the items. What I need is to sum the number of items in EACH deposit. Hope that clears things up. Really, only two columns...

hcount is a single cell. Column h, row count. When count increments, it will run the program through all the rows, looking for a value in column H. At least, that's the plan.

I'm sure this is a simple matter, but I am struggling with it. Basically, I want the program to loop through a single column, like this (Pseudo code): dim count as integer count = 1 do until EOD if hcount = "" select whole row hide whole row end if increment count loop End program. Any...

If it healps, I'm thinking that I can use a loop to do this, breaking at the blank rows between deposits. Still, I can't figure out the "conditional sum" problem, and what exactly the conditions would be (since each cell starts with a number then +$, but the other cells also start with a number...)

Yeah, I've actually been using the Sumif to generate summaries for each one. The problem is, the deposit data doesn't have a consistent length. I need to find the number of bills in each deposit. Here's a little sample: 1 >Declared 1 -8,500.50 Glory GFR 2 +$ 100 6 600 Glory GFR 3...

I'm pretty new to VBA, so here's my question: I have an Excel worksheet with 8 columns of data. I need to sum every few rows in a single column, based on a different column (It's figuring out the number of bills in deposits for a bank, so I need to sum only the columns that are bills while...

A second, unrelated question. Can anyone help me puzzle out why I'm getting an error here: [Mon May 19 15:41:17 2003] [error] [client 127.0.0.1] Can't modify numeric lt (<) in scalar assignment at c:/iperl/cgi-bin/profoundprocess.pl line 216, near...

Here's the deal. We have a perl script that queries a database. We can pull individual records, people who have paid, etc. What we want is a way to access ALL the records, twenty at a time, using little &quot;next 20&quot; and &quot;last 20&quot; links like on a search engine. Right now...