A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Need help with macro for conditional formatting using number forma by Kathy
I need help with a macro for conditional formatting cells using the number format. I can get it to work for bold font or cell color but not number format...
March 23rd, 2010 12:33 PM
by OssieMac Go to last post
1 167
formula for multiple criteria inc. date range by J.Scargill
Hello, I am new to this site and need help with a problem I am having on Excel. I am trying to count the number of cells in column Q that have a "Y" in it,...
March 23rd, 2010 12:20 PM
by J.Scargill[_2_] Go to last post
4 119
Question about syntax for conditional formatting by Cbeckwith
See below: Can someone explain the following in simple language; =AND($B$12"",$B$12TODAY()+120) What does the after the cell location mean? and why...
March 23rd, 2010 11:06 AM
by Stefi Go to last post
6 174
Conditional Formatting by Donna[_5_]
I have a column of numbers that represent the year. I have it formatted as a number. I want to compare that number to the current year. What I did was in...
March 23rd, 2010 09:04 AM
by David Biddulph Go to last post
4 144
combo box by Gabito
Hi: I have a combobox which shows two values: name and age, after I choose "the value", the combo box just shows the "name". I need to be able to print both...
March 23rd, 2010 08:46 AM
by OssieMac Go to last post
1 115
Way do do search/replace on beginning/end of cell w/o functions? by msnyc07
Hi, I've been writing various functions to search/replace beginning/ends of cells, however wondering if there is a way to do the simpler ones with just...
March 23rd, 2010 07:45 AM
by Héctor Miguel Go to last post
1 141
Staff Overtime Form by Freshman
Dear experts, I've a worksheet recording staffs' overtime status. Each row is for one day. For example, a staff input start time and end time in cells A2 and...
March 23rd, 2010 04:22 AM
by Freshman Go to last post
2 119
Help with a IF formula by Pascale
Hi, I was wondering if it is possible to have if and research in the same formula? I need to have a fomula that looks into a cell for a certain item...
March 23rd, 2010 03:21 AM
by T. Valko Go to last post
2 114
How to generate a cell reference from multiple cells by Malters
For example, to acquire the cell reference 'c5' the C is generated by a formula in one cell, and the 5 is generated in a different cell
March 23rd, 2010 03:09 AM
by T. Valko Go to last post
1 128
T.Valko function by Steve
Morning. Back in January I'd posted looking for some help on a function, and T.Valko helped, solving my issue. In using the function, I've run across...
March 23rd, 2010 02:22 AM
by T. Valko Go to last post
5 143
Is this an Index/Match formula? by eflip
Hello - I have 2 tabs of data. The first tab has info by product and its qualifying vendors and non-qualifying vendors (the vendors are in seperate...
March 23rd, 2010 01:02 AM
by Bob Phillips[_3_] Go to last post
5 120
multiple correlations with one click? by bondjel
I have a numerical data set with 11 columns and 1809 rows. I would like to simply obtain a table of correlations involving Col 1 with each remaining Col (Col 2...
March 22nd, 2010 11:22 PM
by bondjel Go to last post
6 154
Create an automatic worksheet with two variables by Cisko
Starting from two values A and B I have to create a table in order to find a final value c. Once I have create that table how can I create another table that...
March 22nd, 2010 11:11 PM
by Cisko Go to last post
0 104
Automating a worksheet in Excel 2003 by hankb
I have a lengthy worksheet that requires one numerical input on A1 and produces one numerical output on F30. I want to apply this process to a column of...
March 22nd, 2010 10:09 PM
by hankb Go to last post
2 120
convert vcf to xls by dave
I'm trying to convert a database from vcf to an excel spreadsheet
March 22nd, 2010 10:05 PM
by JLatham Go to last post
1 127
cell to have comma-delimited values based on text by Richard the Lion-Hearted
I have a table called "220_reference" with a column name "Part Number" having a sample value of below: 4047122(All Dash no.), 4057222(All Dash no.),...
March 22nd, 2010 09:20 PM
by JLatham Go to last post
8 106
Counting for multiple situations by Lisa
I need to be able to count the number of times a meeting is scheduled (did that) as well as the number times a meeting is canceled. Assigned ...
March 22nd, 2010 08:19 PM
by Per Jessen[_2_] Go to last post
3 130
Conditional Formatting Help when a Cell is Blank by Nickle
I am trying to format a cell that has three scenario's. 1. If A1=B1, then the text will be green 2. If A1 does not equal B1, then the text will be red 3. ...
March 22nd, 2010 06:20 PM
by Eduardo Go to last post
2 130
Weeknum Issue by GMc[_2_]
I have a 2003 .xls file that I run on 2007, there is a formula in the file that uses the =weeknum(c2) formula. I am getting an issue where excel is removing...
March 22nd, 2010 06:15 PM
by dawn sadlowski Go to last post
3 116
EOMonth function by Ayo
Is there an equivalent function to EOMonth in xl2003 or a formula that will get me the same result?
March 22nd, 2010 05:18 PM
by Paul C Go to last post
4 115
Post New Thread


Display Options
Showing threads 1901 to 1920 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.