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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
Excel VBA-Geting data from Access by kodricales
My problem is that I don't know how to connect to an Access database from Excel. I'm modifying a macro in which I have to compare some strings in Excel cells...
May 27th, 2004 09:23 PM
by Andy Wiggins Go to last post
2 878
formula to convert 15 minute to hourly data by Luke M[_4_]
This formula should work: =AVERAGE(OFFSET($B$2,(ROW(A1)-1)*3,,4)) this averages range B2:B5 copying down will automatically change it...
May 20th, 2010 04:12 PM
by Luke M[_4_] Go to last post
0 876
Selection after enter by Jeanette Caldwell
After entering data into the active cell, pressing the tab key moves the selection to the right, but pressing the enter key does not move the selection at...
April 30th, 2010 03:43 PM
by JLatham Go to last post
4 874
Calculation by KTC53
In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...
May 20th, 2010 01:13 AM
by ozgrid.com Go to last post
2 870
Duplicates - ?? by JLMcCabes
One worksheet has 600 + lines with a lot of expenses, including SOME of the local expenses. This is a check register.. Another worksheet has 300 + lines with...
April 27th, 2010 04:03 PM
by Gord Dibben Go to last post
5 869
Hiding graphics elements? by Blue Max
How can we hide pre-selected groups of graphics elements with the touch of a cell or control? We have two distinct groups of rectangles with gradient fills. ...
May 2nd, 2010 03:33 AM
by Rick Rothstein[_2_] Go to last post
3 866
filters don't work after combining several spreadsheets into one by Trina
Hi! I could use some help with filters. I have a spreadsheet I distributed to others to complete and return to me. Once I got the copies back I combined...
April 29th, 2010 06:00 PM
by Don Guillett[_2_] Go to last post
3 866
How do I swap data in columns and rows around? by Monkeroo
I've exported a load of data into excel but the info in the columns I want in rows and vice versa. I'm sure there must be an easy way to flip them.. Can...
May 28th, 2010 03:16 PM
by tim m Go to last post
2 862
Rephrasing Interior.ColorIndex 36 question. by Linda
How can I write a formula for a column of colors, (some have numbers, some don't) that will go down the column and look for Interior.ColorIndex 36 (light...
May 28th, 2010 01:49 PM
by Luke M[_4_] Go to last post
1 861
May 16th, 2010 05:06 PM
by Gord Dibben Go to last post
1 860
Date format clarification by Blue Max
When a user selects the 14-Mar-01 standard date format in Excel 2007, then selects the custom format option, this is the standard format that...
April 7th, 2010 02:36 AM
by ozgrid.com Go to last post
6 859
Find & Replace in XP by Jane
XP now has the ability to do a find & replace based on formatting, but i ran across an issue. If I type the word accountant in cell A1 and "accountants are...
April 27th, 2004 12:29 PM
by Tushar Mehta Go to last post
3 856
Finding maximum value by Ruan
Hello, I want to find the maximum value in a column, but I want to ignore the negative and positive part of the value. Basically, the maximum difference from...
April 27th, 2004 08:30 AM
by JE McGimpsey Go to last post
3 855
Quarterly Formula by Caroline
Is there a formula to obtain a total for each quarter which excludes including the year? Thus avoiding having to change to year on a yearly basis. Your...
April 13th, 2010 06:20 PM
by Caroline Go to last post
2 849
Sum of retuned valus as digits by Vinay Vasu
Hello there, I am using IF function to return values as digits. Now I need the sum of such digits in a coloumn. Pease help me to do this. Thank you Jeevan
April 22nd, 2010 09:19 PM
by Brad Go to last post
5 846
Hyperlink problem and question by Shawn
I created a hyperlink to a pdf file ,it flashes and closes whats wrong??? \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make...
April 9th, 2010 12:28 AM
by Dave Peterson Go to last post
1 844
Combo Box by josros60[_2_]
Hi, how can i make this code work in Combo Box (Activex Control) to populate data fields in excel? I got it to work in Combo Box (Form Control) but it will...
May 29th, 2010 05:39 PM
by josros60[_2_] Go to last post
0 843
deleted text character returning numbers when deleted. by Trreborr09
why would a value in a cell as shown here 8212.0011( return a value of 8212.00110000.00 when the ( character was deleted from the cell? The version of excel...
April 11th, 2010 03:17 AM
by ozgrid.com Go to last post
3 841
formula for copy and paste by robbie5
can i create a condtional function in a cell that would send data in one row of cells to a cell in another worksheet. ex a1 a2= aaaa a3= bbbb a4=cccc a5=if a1...
December 27th, 2005 10:59 PM
by bpeltzer Go to last post
2 841
Converting Quatro Pro files to Excel by Phil at Richardson
We have a large number of files used in product costing, which have been created in Quatro Pro 7. We would like to begin using Excel, instead of Quatro Pro. ...
May 6th, 2004 07:19 PM
by Ken Wright Go to last post
1 839
Post New Thread


Display Options
Showing threads 121 to 140 of 13737
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 12:49 AM.


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