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
how do I merge multiple csv files in one Excel file? by Nedulous
I have 200 csv files with data that I want to merge into one Excel file for sorting purposes.
May 17th, 2009 04:07 PM
by Ron de Bruin Go to last post
4 137
need qualifier statement by Abbey Somebody
Hey guys... I have a weekly check sheet and the days of the week auto-fill from the "week starting date" that I fill in in another cell. That works fine. ...
May 17th, 2009 03:11 PM
by Abbey Somebody Go to last post
5 158
Count Unique Values in 1 Column based on Date Range in another Column by Brian[_16_]
Howdy All, I'm use the CountU function to count unique values in a column and it works great! Now what I want to do is count the unique values in Column B...
(Multi-page thread 1 2)
May 17th, 2009 02:58 PM
by Brian[_16_] Go to last post
14 232
how to represent x,y coordinate in single column? by co-ordinate
As i want two cell data in new cell separated by comma, which we can use as a co-ordinate (x,y) in other CAD software. Can somebody help me in this issue?
May 17th, 2009 02:38 PM
by Jacob Skaria Go to last post
3 157
Formula help in Excel 2007 by Millie[_2_]
I know it's possible to link cells from one worksheet to another but not sure if what I want to achieve is possible (I use only the basic functions in...
May 17th, 2009 02:25 PM
by Ken Johnson Go to last post
3 171
year - 1 by alvin Kuiper
Hi Is there a way in a worksheet - Functions where i can take a cell value (date) and make it a year less like 01-11-2009 (danish date) shall be 01-11-2008...
May 17th, 2009 06:12 AM
by macropod[_2_] Go to last post
5 130
I'd like to change my column markers from numbers to letters by Excellence
Worksheet columns are labeled with numbers, making formulas very difficult to follow (=RC*RC) instead of (B13*M7). Thanks for help.
May 17th, 2009 05:43 AM
by T. Valko Go to last post
1 162
Macro:- Find first blank cell and write text by Mac0001UK
Hi All, I have a spreadsheet in 9 Columns (A to I) and, at the moment, 772 Rows. I want to write a macro that:- Finds the first blank cell in column B, (ie...
May 17th, 2009 02:34 AM
by Mac0001UK Go to last post
4 181
Is there a formula to calculate the least common denominator? by Gizmo
I am trying to find a formula that will give me the least common denominator for doing a cost account spreadsheet with sales mix.
(Multi-page thread 1 2)
May 16th, 2009 10:39 PM
by Greg Lovern Go to last post
16 279
Approximate match on string of text by Pierre
I am looking for a solution to the following problem: I have a long list of companies in an EXCEL sheet, and would like to find, company by company, if there...
May 16th, 2009 10:27 PM
by Greg Lovern Go to last post
7 175
Countif question by Patrick C. Simonds
I need to be able to check the range D19:AB19 for any occurrence of the phrase On Call. That is easy enough with the formula below so my problem is it could...
May 16th, 2009 09:36 PM
by Domenic[_2_] Go to last post
4 123
Calculating a dollar-weighted return by Petrak
I am trying to calculate a dollar-weighted investment return for a month period with some cash flows on some days in the month, For example: Jan 1: $100 ...
May 16th, 2009 09:36 PM
by Petrak Go to last post
3 135
Count Unique Values in a entire column, not just range by Brian[_16_]
Howdy All, I have a formula: =Sum(IF(Frequency(Match(A1:A14000,A1:A14000,0),Match(A1:A14000,A1:A14000,0))0,1)) Which will give me a count if the unique...
(Multi-page thread 1 2)
May 16th, 2009 08:48 PM
by Bernd P Go to last post
10 248
Summarize range by willemeulen[_10_]
I want to make an automatic summary of value's present in a certain column in ascending order. Example: Column 8 10 12 10
May 16th, 2009 08:11 PM
by Domenic[_2_] Go to last post
4 175
Problem working with Vlookup by Patrick C. Simonds
I have the following table (A1:B6) from which I want to return the appropriate value from column 1. This is my formula: VLOOKUP(R16,'Sunday...
May 16th, 2009 07:49 PM
by Domenic[_2_] Go to last post
3 90
matching texts in 2 columns by my_melody
Can I match texts in 2 columns (one column has a longer string than the other column so let's say it should be able to match the first 5 characters) and then...
May 16th, 2009 05:21 PM
by Jacob Skaria Go to last post
1 103
how do i get excel text to change colour at a certain limit by lardarse
i am setting up an employee absence sheet whereas people are allowed 10 days sick leave before action is taken, i want my sheet to turn red at number 9 so...
May 16th, 2009 04:44 PM
by Mark Go to last post
2 125
Text Separation Function by kateconrey
I have a database with one column of information including names (First Last, or First Middle Last) and for some names, locations in parenthesis. I am...
May 16th, 2009 03:14 PM
by Ron Rosenfeld Go to last post
3 235
Count based on two criteria. by MJKelly
Hi, How do I get a summary of a table of data according to two criteria? I want to check instances of "A" in one column and then where "A" is found, check...
May 16th, 2009 02:41 PM
by MJKelly Go to last post
2 137
need one formula for % change in TY vs LY revenue by Gene
I Need to know the % change of revenue $ from this year(TY) vs last year(LY) with one formula. I am using TY – LY / LY = % change but result is not...
May 16th, 2009 02:08 PM
by Gene Go to last post
8 150
Post New Thread


Display Options
Showing threads 11001 to 11020 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 06:05 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.