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
Missing Record in Table Lookup by Jim
I'm using Excel 2007. I have created a table with customer numbers, names, status, and several other columns. I named this table including the header row...
March 25th, 2010 05:58 AM
by Jim Go to last post
0 124
Using Sumproduct when some of the values are null by SanCarlosCyclist
I am having a problem using Sumproduct when some of the cells have null values. I will try to describe the problem. Please let me know if you need additional...
March 25th, 2010 04:25 AM
by SanCarlosCyclist Go to last post
5 126
find by cmkwolf
I am trying to set up a worksheet at work that lists case numbers in the following format ab12345 how do i do a search for a specific case and I want to...
March 25th, 2010 04:21 AM
by FSt1 Go to last post
1 137
Vlookup possibly ? by Steve
I have this data in rows C, & L thru P. In C6, if I manually enter a 3, I need the data in row 17 to populate row 11 as shown (L11="", M11="",N11=-972,...
March 25th, 2010 03:04 AM
by Pete_UK Go to last post
3 123
Looking for Text strings by Scats
I lost all my data and have to redo my home spreadsheet, but It's been awhile since I made it and I have forgotten some of my formulas. I need a simple one...
March 25th, 2010 12:38 AM
by Scats Go to last post
3 147
Segrigation of different datas from one colum by Roy Thomas[_2_]
Hi , I am trying to segrigate and pull data from one colum to different colums. For this I want to created a macro . Also I want this data to be pulled...
March 24th, 2010 11:33 PM
by ker_01 Go to last post
1 131
Excell Spreedsheets by Jack Wheeler
I have thee monitors running at one time. How can I work on two Excell spreadsheets at a time and be able to run one on one monitor and the second on another...
March 24th, 2010 11:15 PM
by Tony Go to last post
1 208
Circular Reference Warning ??? by Soth
Hi I receive a this message 'Circular Reference Warning'...One or more formulas cantian circula reference and may not calculate correctly. How is this...
March 24th, 2010 10:03 PM
by Jim Thomlinson Go to last post
1 170
Indirect and Sheet Name by Rob
I have a formula =COUNTA(INDIRECT(A3)) which returns the count of items in a range which is defined in cell A3, the formula in A3 is below. Is there a way...
March 24th, 2010 09:56 PM
by Rob Go to last post
4 148
mark up by arKwelder
need to mark up 16800 items by 15% column e is my net and need column f with new prices
March 24th, 2010 09:51 PM
by David Biddulph Go to last post
3 117
Select 'Sort By' column by simply typing heading letter by dsavant
Hello, In the next version of MS Excel, please restore the ability to define Sort By columns by simply typing the Column heading letter as was the case in...
March 24th, 2010 09:03 PM
by Roger Govier[_8_] Go to last post
1 138
Downward column by climate
Hi suppose that,my data set on column x and second row(x2),i want to move this column to desired row. For example: data position is x2 and expected position...
March 24th, 2010 09:01 PM
by climate Go to last post
1 137
Pivot Table Refresh by Eric
I believe there is a way to create a button to refresh multiple pivot tables within the same file, but I can't seem to figure it out. I'm creating a model...
March 24th, 2010 08:55 PM
by Eric Go to last post
5 148
Trying to convert mm/yy in text to Dec-07, it adds day & current y by Excellency
I have a cell that has mm/yy = 07/09 , I want it converted to display Jul-2009 or Jul-09. But when I use DATEVALUE or format cell, it displays 09/07/2010 and...
(Multi-page thread 1 2)
March 24th, 2010 08:52 PM
by Héctor Miguel Go to last post
12 281
Pivot Table - Calculated Field by Mike C
I have 3 fields, Building, Employee, and Sales. I have about 3,000 records in total. I can run a simple pivot table to show by building which counts the...
March 24th, 2010 08:50 PM
by Roger Govier[_8_] Go to last post
2 113
Row Height Adds Blank Space at End of Text by Meg
Hi, We have a spreadsheet where the row height is automatically expanded to add extra, blank space at the end of the cells. We manually adjust the row...
March 24th, 2010 08:17 PM
by Meg Go to last post
0 138
Calculate Number of Days worked in Each Month by Project by froggygremblin
I want to calculate the number of days worked on a project in a rolling 4 month calendar. Working Days are Mon-Thu. My sheet looks like this: Jobname...
March 24th, 2010 07:49 PM
by froggygremblin Go to last post
2 128
SELECT SUM(h) WHERE e = 'eBay Payment Sent' by yawnmoth
If SQL queries could be performed in Excel, I'd do "SELECT SUM(h) WHERE e = 'eBay Payment Sent'". Since SQL doesn't support SQL, however, I need to try...
March 24th, 2010 07:42 PM
by T. Valko Go to last post
4 123
Redistribution of values after reaching maximum by DG
Hello, I am trying to build a formula to to resolve the following scenario: Column A Column B Row 1 ...
March 24th, 2010 07:31 PM
by DG Go to last post
4 122
adding figures that match 2 true and 1 false if statement conditio by UKMAN
As ever many thanks in advance for any help. I am struggling to understand how I can say not equal in an if statement in excel:( I need to consildate a...
March 24th, 2010 07:09 PM
by Eduardo Go to last post
5 208
Post New Thread


Display Options
Showing threads 1841 to 1860 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 05:36 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.