Recent content by estone4009

I have an excel file that has one column and 39,980 rows. I need to take that and have it put it into a comma seperated file. Ex. A1,A2,A3,A4 I need all of these in a single line file. Any ideas? Thanks!

Because each value is in a new row it doesn't put it in a comma delimited file. It just puts each on its own new line. That woul work if I could replace each new line start with a ,.

I have an excel file that has one column and 39,980 rows. I need to take that and have it put it into a comma seperated file. Ex. A1,A2,A3,A4 Any ideas? Thanks!

I have 12 columns each containing a 0,1,2,3 or 4. How can I take these 12 columns and have it total the 0's,1's,2's,3's and 4's into 5 more new columns? Again, I want it to count the number of 0's for example and place that in a new column. The numbers corespond to how long an account has...

I currently have a 2000 Server acting as my domain controller, file server and terminal server. We are wanting to move the terminal services to a new standalone server running 2003 Server. I have 30 Windows 2000 server CAL's and 15 Windows 2003 Terminal Services CAL's that I use now. I know...

I'm wanting to prefill a sheet with the formulas needed so that a user only has to enter two values and print the results. But I can not fill the formula down or I get #DIV/0 errors and they print on the sheet. How can I have these formulas pre filled down but hide the Divide By zero error...

We have a Samaba share set up on a Windows 2000 Server box and are able to browse the share with ease. We are trying to move files from the Samaba share to the windows drive. When we run a batch to move them the move completes but the final removal of the files from the Samba share do not...

We have a Samaba share set up on a Windows 2000 Server box and are able to browse the share with ease. We are trying to move files from the Samaba share to the windows drive. When we run a batch to move them the move completes but the final removal of the files from the Samba share do not...

I have a sheet set up witht he correct formulas and I want the way it is now if I use auto fill I get a bunch of divide by zero errors. The user will enter a new new line of data every week and doesn't need to see pages and pages of Divide by zero errors. Is there a way to have it autofill...

Close but not exact. If A1=100 then I only need it to multiply the last 20 not the full 100.

Here is what I need: Anything in column A with a value higher than 80 then it takes the amount over 80 and multiplies it to column D to equal column E.

I tried the second formula but I need to give you more details. I over guessed on the number of values in my Rows. Row A: 7109 Row B: 6923 Row C: 13747 Row D: 13973 The formula seemed to work but after Row A and Row B ran out of Data the True and false kept going. Do I need to just swap Row...

Here is what I have: 4 columns of data (50,000 Rows each) I want something to search each 4 columns of data write a new list(column or worksheet) of the values that appear in all 4 columns. Any ideas on how I can do this quickly?

I need some advice on the best way to transfer software between Symbol LRT3840's. I have several units and I need to copy the client software from one to another. Thanks

I have found that our data connection speed was the cause of most of our problem. We went up to a Full T1 1.5Mbs and that took care of most of the lag. I did find though that the Wyse 3360se would not connect across the connection to use DHCP to receive it's address. That has to be done...