Pages

Search

Excel Help Forum - Excel Formulas & Functions: What formula to use for matches in column and return the sum of all match val...

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
What formula to use for matches in column and return the sum of all match values in adjace
Hello, I need help to find the appropriate formula to find all entries in a column (in this case C) and add all entries in an adjacent column (in this case d) each time the reference is entered. If my verbage is not clear let me know and I will try to explain better. Thanks, Mark

Excel Help Forum - Excel Programming / VBA / Macros: It's possible to create an "autorization" or reject button with vba excel?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
It's possible to create an "autorization" or reject button with vba excel?
Good Afternoon! Thanks for your answers, have helped me to go learning excel vba excel! ;) I have a question.. I'm working on a time system tracking, and I want to know if it's possible to have a button for authorization (and sent by mail to me) to authorize or reject the workbook.. Is it...

Excel Help Forum - Excel General: [SOLVED] help with formula. It works but empty cells show#VALUE

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] help with formula. It works but empty cells show#VALUE
I have attached a sample workbook and in it I have surprised myself by ammending a formula, it works but when the cell is empty I get #VALUE in the cells, I would like the cells to be empty. It's difficult to explain but it is obvious if you would take a look at my sample. Thank you.

Excel Help Forum - Excel Formulas & Functions: Value return from two column comparison

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Value return from two column comparison
Thanks to anyone who can help me! I work for a medical practice, and I'm trying to quickly find the payments of our contractual reimbursements based on the insurance name and CPT (procedure code). Hopefully I'll explain this clearly...I have a spreadsheet where I'm trying to get a return...

Excel Help Forum - Excel Programming / VBA / Macros: have a drop down list with associated values difference to be calculated

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
have a drop down list with associated values difference to be calculated
hi all! in the attached file you will find in cell K1 a drop down list of all possible start values and in cell L1 end values. i want the program to be able to have someone choose a start value say for instance A.3.3 ( which corresponds to Line 13's data.) and a stop value of A.6.1 (line 22's...

Excel Help Forum - Excel General: R1C1 reference style default checked - driving me crazy

Feed2Mail notification - new post on Excel Help Forum - Excel General
R1C1 reference style default checked - driving me crazy
Does anyone know how to permanently uncheck that option? If you click the MS button, then "Excel Options", then ""Formulas", it is the first option in the "Working with formulas" section. This being checked makes your alpha columns display as numerals. Not a big deal until you try to copy a...

Excel IT Pro Discussions Forum: Combine multiple Excel workbooks and export to a single html page

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Combine multiple Excel workbooks and export to a single html page

I'm trying to find a new solution in Excel 2010 from 2003 that allows the ability to take multiple Excel documents with only one page each, auto select the data for the print area, and publish to a single HTML file.  This needs to be done in a chronological order by the date of the file.  I'm not sure if this can be done as a script within Excel or if there's a third party program which can help with this capability.

I'm not an Excel guru and could use your help.

Thanks!

Excel IT Pro Discussions Forum: I need a macro that does this (Two excel sheets shown)

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
I need a macro that does this (Two excel sheets shown)

My macro worked before to do what I needed to do but for some reason it either was wrong before or I just thought it was working. Anyway here is an example of two spreadsheets, the one on the left is prior to the macro and the one on the right is after the macro. The idea is simple and below the examples I will explain my logic and show my code. Please let me know if anyone can help asap I am getting confused.

As you should be able to see from my example my macro reads out the value in Column C "WP". It then compares it to the value above in Column C and when that value changes the value in column F "Name" will copy the name of the task that started the change. So MGMT overwrote Task3 and Task because the WP value changed. It also should read the offset value and keep copying down the task name until the "WP" changes again.

Here is my code I have been trying to use. (It runs from a project user-form but it is excel mostly)

Private Sub Test()      Dim xlapp As Excel.Application   Dim NC As String, tn As String   Dim xlSheet As Worksheet   Dim c As Range      Set xlapp = GetObject(, "Excel.Application")   Set xlSheet = xlapp.ActiveWorkbook.Worksheets(1)   NC = xlSheet.UsedRange.Rows.Count   For Each c In xlSheet.Range("A2:A" & NC).Cells       Debug.Print c.Value       If c.Offset(-1, 2).Value <> "" Then           tn = c.Offset(0, 5).Value       Else           c.Offset(0, 5) = tn       End If   Next c   End Sub   

Excel Help Forum - Excel Formulas & Functions: If worksheet 1 cell A1 contains one the following N/S, OP, AFT 1 display a value

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
If worksheet 1 cell A1 contains one the following N/S, OP, AFT 1 display a value
Hi Please help me..... I am looking for a solution to a problem that I have spent a week trying to figure out and I am struggling to find the solution. If worksheet 1 cell A1 contains one the following N/S, OP, AFT. N/S I need to display number value 3 in worksheet 2 cell A1

Excel Help Forum - Excel Programming / VBA / Macros: Macro to separate out raw data

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro to separate out raw data
Very difficult but any help or direction would be GREATLY appreciated. Here is what I am trying to accomplish: I am trying to write a macro that will separate out the 'Data' tab in the attached document. It will look in Column 'D' from the 'Data' tab and match the name with the worksheet. ...

Excel Help Forum - Excel General: Replace missing values

Feed2Mail notification - new post on Excel Help Forum - Excel General
Replace missing values
Hi. Is there a way to find-replace missing values with a "." or something of that sort? Can't seem to figure out. Thanks.

rpm problems.. - Forums Linux

rpm problems.. - Forums Linux


rpm problems..

Posted: 08 Feb 2004 01:23 AM PST

>> hi all 

I expected to find it somewhere under the /usr/src so I did a
find /usr/src -name version.h to try to locate it. from what I
understand version.h is one of the files the driver-source needs.
nothing.
I also looked in /usr/src/redhat/SOURCES and found nothing that seemed
to be kernel-sources.

As I said I found it strange that GnoRPM think it's not installed (I
checked on my laptop on which I know I have that package to see where
it was located)
 

I did a lspci and it said "network-card unkown interface" or similar


regards
Daniel

How can I auto mount usb key when I plug it ?

Posted: 07 Feb 2004 01:36 PM PST

 

Yes I found /etc/hotplug/hotplug.agent.
But how am I supposed to modify the script ?
Must I find out where the action for an usb key is made and call my own
script on plug and unplug ?

I mean, I don't want to break the whole thing :)

thx for you input though


where do I install openoffice 1.1 on knoppix 3.3?

Posted: 06 Feb 2004 09:01 PM PST

walterbyrd a écrit:
 
I do not know any specific about knoppix but:

1) The setup of OOO asks you where *you* want it to install. I suggest
/usr/local/some-sub-dir/ or /opt/some-sub-dir/ ; depending on your
partition scheme.

2) It is better to use ./setup -net if you want OOO to be readily available
for everybody in a multi-user environment.

3) The doc that comes with the package(?) is well written and explains the
install process.


Bonne chance!
--
On ne peut pas transporter partout avec soi le cadavre de son père.
Guillaume Apollinaris de Kostrowitzky

How to move personal config/home dir to another computer?

Posted: 06 Feb 2004 08:51 AM PST

Horus Alkebulan wrote: 
sure you can do that. Login as root, create a user for yourself, get
those config files here. But make sure you chage the owner and group of
the newly transfered config files. That what I do all the time I install
GNU/Linux afresh.

GVK

--
Happy Hacking!!!

Suggestions wanted for simple File Server linux variant..

Posted: 06 Feb 2004 05:57 AM PST

"Frank Perdue" <com> wrote in message news:<c006gk$8ou$panix.com>... 

I'm assuming you're pretty new to Linux, so I would suggest you go
with Redhat or SuSE or Debian simply because of their availability and
wide use. These also may be easier to "sell" to others if you have to
get other(s) to OK the distro. Other distros fine too.

I wouldn't purchase any Linux distro till I was familiar with it and
understood just what I was purchasing. To get started go with a
downloadable version or buy a Cheapbytes cd:
http://www.cheapbytes.com/
Code/configuration wise you won't notice a difference with the pricier
fair.

I would not recommend a "headless" server till you are comfortable
with Linux and your distro in _your_ network environment. Trying to
do all your setup (OS and users) -- not to mention installation --
remotely with an OS you're not familiar with will add more confusion
than it's worth. All you need is a cheap (used/spare) video setup and
a keyboard. What will you do if the file server goes down? If the
network goes down? If your laptop goes bonkers? It's just not worth
it and may be necessary anyway after a power outage crash. Considered
an UPS?

Later, after you're comfortable with your basic setup, you might want
to try something like Webmin to do remote administration:
http://www.webmin.com/
Ultimately, you'll want to learn to telnet (or SSH) into the server
just in case.

You'll also need to decide just how you want to provide remote file
access to users. You'll need something that both the Win and Mac
clients can easily reach and that Linux supports (and that you can
administer without too many headaches).

Looking at some distro manuals and Linux howtos should help out before
you dive in with sleeves rolled up. Check these links (which I had
handy):
https://www.redhat.com/docs/manuals/linux/
http://www.tldp.org/docs.html
Google for other distros also to get some basic sense of what's
available.

Also consider that whatever you go with has a way of growing into
adding a web server, a mail server, a print server, etc., as Linux
makes a fine platform for all these (and many more) services that will
run nicely on older, cheap hardware. Pick a distro with an eye to the
future.

As a last check you might want to Google your hardware together with
specific distros or just Linux. Eg., you might search with:
LSI SATA raid Linux
or
LSI SATA raid Redhat
or
LSI SATA raid SuSE sendmail <- up to 10 words

You get the picture. Use Google to search NGs the same way. You can
learn quite a lot this way and get practice providing your "own"
support rather than paying. It may be all you need.

hth,
prg
email above disabled

Display Corrpution/SaX2 configuration

Posted: 06 Feb 2004 04:20 AM PST

Ruari Callow wrote: 

IMHO, this was worth hashing out in front of the wider audience. Laptops
are ever more popular, and there's precious few sites specializing in
their unique issues. That is, precious few sites easy to find. Your
question strikes me as proper use of the NG, so I'll defend it. About
the only way it could be more useful is if you had done all the work,
wrote it up in summary and then posted that. Tall order, if you ask me,
and I happen to be a writer of just such articles (see ofb =dot= biz).


--
Ed Hurst
--------
Return address is a spam trap;
try softedges =at= gmx =dot= net.

AMD 64 bit processing and SUSE 9.0 (Kernel 2.4.21) - compatibility query

Posted: 06 Feb 2004 01:45 AM PST

David Brook wrote:
 

Take a look at this url:
http://www.mushkin.com/epages/Mushkin.storefront/4023799d00d11858273fc0a801020617/UserTemplate/27

It might give you some useful information


--

Linux Triple Boot

Posted: 05 Feb 2004 02:58 PM PST

Mitesh wrote:
 

For hardware, if your computer is standard: put both drive pins to
"Cable Select". Then plug the 120GB to the far end on the cable (i think
it might be blue???). Then plug the 20GB drive in the 2nd position
(between the 120GB and the motherboard). Set boot order in the bios to
the 120GB drive.

This is my _opinion_, and I _personally_ recommend installing the
following way.

1. Create 80GB with XP Installer, install XP.

2. Install RH9. This requires MINIMUM 2 partitions, a root "/" partition
and a swap partition. Create both, do the recommended swap size
(depending on your RAM).

*** Its good to have a separate partition to store data. Create a 3rd
/home partition if you want. Make it big >20GB. You won't need more than
10-15GB for a full install of RH9 with enough room for just about
everything conceivable.

*** Install GRUB boot loader to the 1rst sector of the Redhat boot
partition. NOT on the MBR. Use bootpart to create an entry in the XP
boot loader (already in windows) to boot redhat:
http://www.winimage.com/bootpart.htm

3. Install Suse on the second drive. Use its recommended partition
scheme. Even though suse can use the swap partition on the first disk,
it may want a separate swap on the 2nd disk.

Also install grub to the first sector of the (suse) boot partition. You
will need a 2nd entry in the XP boot loader to boot suse. Use bootpart
again.

------

However, if you dont want to use the xp boot loader, you must install
grub to the MBR for RH9. Then, for Suse you will need a separate entry
in grub to point to the second disk. The good thing about using the xp
boot loader is it doesnt affect xp booting in any way. From experience
locking yourself out of booting XP is much more frustrating than locking
yourself out of linux (since its easily fixable).

Whatever you do, always install windows first! Also try to keep all
windows partitions (ntfs, fat, etc) before linux partitions (ext,
reiser, etc) when installing on the *same* drive. This has caused me
some pain in the past.

Hope this helps, good luck.

--

Mauriat (www.mjmwired.net)
----------------------------
Remove 'NOSPAM' to email me.

2G memory not recognized

Posted: 05 Feb 2004 09:19 AM PST

Davide Bianchi <net> wrote in message news:<bvu1du$10u0l7$news.uni-berlin.de>... 

I was under the immpresion that redhat kernels support mem >= 2G,
and on a different server which is i686 that is fine. Is high mem
configure only in the i586 kernels?

[sorry, that should have gone to a redhat list]

Thanks

How to remove Red Hat Network Alert Icon permanently from the panel?

Posted: 05 Feb 2004 05:53 AM PST

joensuu.fi wrote:
 

Well, the obvious question is:
Did you save the settings?

--
Fedora Core 1, Kernel 2.4.22-1.2135.nptl, KDE 3.1.4, Xfree86 4.3.0
23:35:00 up 34 days, 5:15, 4 users, load average: 0.09, 0.13, 0.09
It's what you learn after you know it all that counts

xmms-infopipe problem

Posted: 04 Feb 2004 09:55 PM PST

Dave Abbott wrote: 

I got xmms 1.2.9 and xmms-devel-1.2.9
Things run smoothly now. Thanks for your time.

GVK

--
Happy Hacking!!!

PCMCIA.IMG for LiveCDs?

Posted: 04 Feb 2004 08:23 PM PST

On Thu, 05 Feb 2004 22:16:55 GMT, Les Denham <com> wrote:
 

Thanks,

Have already tried that with PCLinuxOS LiveCD and Mandrake 9.1
pcmcia.img. It doesn't work. I guess the image file has to be matched
to the distribution exactly, or the install is aborted with a "wrong
version" error.



Achim



axethetax

Problem with ext3 filesystem on Redhat 7.3

Posted: 04 Feb 2004 01:45 AM PST

com (P Gentry) writes: 

Note that the size you see with 'ls -l' shows only the end-of-file
pointer. ls -ls will show the number of blocks actually allocated
to the file. It is perfectly legal albeit unusual to have a file which shows
an EOF of 282GB on a 9GB drive, if most of the file is empty.

scott

Excel Help Forum - Excel Charting & Pivots: Dynamic Multiple Charts - One Data Set

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Dynamic Multiple Charts - One Data Set
Hi Guys, I'm particular stumped by this problem and would appreciate any help you could provide. If you look at the attached spreadsheet you'll see I have a 2 year data set for each LOB. The reason being is I need to do a rolling year chart for each LOB, for example if I did one now it would...

Excel Help Forum - Excel Formulas & Functions: Formula with Different Percentages

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Formula with Different Percentages
I need to create a formula that allows me to multiply one cell by another, but the percentage in the second cell would change based on the number in the first cell. For example – the first 20 participants will pay $10, but if they have 30 participants, the next 10 get 15% off, and the 10...

Excel Help Forum - Excel Programming / VBA / Macros: recursive correlation

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
recursive correlation
Hi guys! I was wondering if you can help me - i am a bit of an excel novice, but am trying to learn... :) I have a very long bivariate series. say, for example, 1....500000, in columns a and b. I then want to analyze the series into blocks of 100. I want to look at correlations for each...

Excel Help Forum - Excel General: Word slowing down using >paste special< with no links

Feed2Mail notification - new post on Excel Help Forum - Excel General
Word slowing down using >paste special< with no links
I am working on a Word document and pasting Excel tables and charts into same using Paste Special without the links. At regular intervals the Word document freezes and I have to wait a minute or 2 until it recovers. Is there a way of fixing this problem or is the only alternative to copy and...

Excel Help Forum - Excel Formulas & Functions: Converting a date serial number back to a date within a string

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Converting a date serial number back to a date within a string
Hi all, I'm working on something that will return the applicable dates given certain conditions. I have one condition that would return a date range. I am currently trying to use, as an example: =if(A3="Marriage", A3&" - "&A3+31-DATE(A3+31)+1) In theory, this would return 10/15/2012 -...

Excel Help Forum - Excel Programming / VBA / Macros: Copy values from one CSV to an excel worksheet?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy values from one CSV to an excel worksheet?
Is there a way that you can have a macro automatically copy and paste values from one excel sheet to another and possibly reformat some of the copied information?

Excel Help Forum - Excel General: Running clock in excel 2010

Feed2Mail notification - new post on Excel Help Forum - Excel General
Running clock in excel 2010
Hello. Is there a way to build a running clock that automatically scrolls through a selected range on a dashboard. I have attached a very basic mock upAttachment 188555 (http://www.excelforum.com/attachment.php?attachmentid=188555)

Excel Help Forum - Excel Formulas & Functions: Frustrations with Pivot Tabels

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Frustrations with Pivot Tabels
Hello, I'm probably going to kick myself when this finally sinks in, but I'm having trouble getting data out of a pivot table. On the attached book the sheet 'Age of Stock' shows a stock item, a date and a quantity. On sheet 'Stock Report' in cell M4 i want to match the stock item...

Excel Help Forum - Excel Programming / VBA / Macros: Only one computer adding leading apostrophes to drop downs

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Only one computer adding leading apostrophes to drop downs
I am testing out a tool that I have been working on for the past few months, and I have sent it to several people on my floor to test it. It works fine for everyone. I tried to give a demo to a manager this morning, but on his computer it kept getting errors. The tool is built to set pivot...

Excel Help Forum - Excel General: Mail Merge: The merge provides data from the previous record

Feed2Mail notification - new post on Excel Help Forum - Excel General
Mail Merge: The merge provides data from the previous record
I hope someone can help please. I have created a data source (Excel 2000) and the data is sitting in the right columns; I have also created a word document (Word 2000) for the mail merge. I have inserted the merge fields into the word document but when I preview the merged document (using...

Excel IT Pro Discussions Forum: Excel/Sharepoint

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel/Sharepoint

I have a very an App with, multiple SSs and charts. I would like to make the App available to many clients  via the web instead of downloading the app to their computer. I understand, however, that when attempting this porting (HTML Conversion) many features that I am using will be lost.

Can Sharepoint be a solution, i,e., web access to Excel with no loss of local Excel features???

 

Excel Help Forum - Excel Formulas & Functions: advanced excel counting with running totals

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
advanced excel counting with running totals
I have an excel spreadsheet--in which I cannot use VBA (for security reasons)--and I am trying to count cells. Each day that an occurance does not happen, an accident for example, I add 1 to the current day (for weekdays) and one for each weekend. However, if an occurance does happen, I need to...

Excel Help Forum - Excel Programming / VBA / Macros: Need help in Search database

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Need help in Search database
Hello! I am building a search database. The data that I have is captured as below (Just an example of how the database looks Index1 | Index2 | Data1| Data2 | Data3 10 | 50 | A | B | C 100 | 150 | X | Y | Z