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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
help with formulas, don't know where to start! by Ed
I have to worksheets and I need to bring numbers from one Worksheet to the ohter kind of like this: worksheet one looks like this column a column b 1 ...
May 11th, 2010 06:29 PM
by Ed Go to last post
4 255
Populate cell with data from another worksheet by FP Novice
I would like to flag a cell with an A for active or I for inactve (lets say cell A1) and based on the entry have another cell (G1) populate an entry from...
May 11th, 2010 06:22 PM
by FP Novice Go to last post
4 232
Totals in one cell by tl
What would be the formula if possible for this setup I'm trying to use? Cell A Cell B 2 67 When I input 2 in cell A, I want cell B to...
May 11th, 2010 06:21 PM
by tl Go to last post
6 240
Equations converted from 2007 to 2003 not sorting properly. by Geoff[_13_]
I have a spreadsheet in 2007 that I need to save in 2003 format so some people can use it. The table records are in rows. Here’s what one equation looks...
May 11th, 2010 06:20 PM
by Geoff[_13_] Go to last post
0 164
Cube refresh Date by Lakshmi
Hi I have a requirement to display the cube refresh date in my Excel report. I know that if you click on Data tab in the ribbon and choose Properties tou can...
May 11th, 2010 06:19 PM
by Reeza Go to last post
1 207
2003 Filter and Sort Ascending by Rob
I have a database with over 2000 entries. I generated the database in excel 2007, but my clients only have 2003. When they sort the zipcode field in...
May 11th, 2010 06:16 PM
by Gord Dibben Go to last post
1 266
Combo Box by FP Novice
I want to use a combo box in place of a Vlookup function. I have a list of 2048 possible logical ID's for some equipment. I want the keeper of the record to...
May 11th, 2010 06:04 PM
by FP Novice Go to last post
0 156
Input in Column IV if countif satisfied by FIRSTROUNDKO via OfficeKB.com
Hi, I am trying to input "WRONG" in COLUMN IV if the countif changes the cell colour. this part of the code is not working though Range("IV" &...
May 11th, 2010 05:43 PM
by Luke M[_4_] Go to last post
1 225
decap names from transferred data by goathead
How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
May 11th, 2010 05:28 PM
by Gord Dibben Go to last post
6 239
how do I convert a spreadsheet to landscape format? by mike
how do I convert a spreadsheet to landscape format?
May 11th, 2010 05:09 PM
by Billns Go to last post
3 241
too many columns for screen can't see all by Ack!
Suddenly, all of my excel files now have around 30 columns, even if I try to start a new book. The columns take up so much space I can't even get a slider...
May 11th, 2010 05:07 PM
by Billns Go to last post
5 203
How to delete the word I typed on the excel page? by Loan Duong
How to delete the word I typed on the excel page? Please help! Thanks! Loan
May 11th, 2010 05:05 PM
by Billns Go to last post
3 192
Macro to goto specific cell (todays date) by crimekilla
i have a sheet set up as follows A B C 1 John Andrew ...
May 11th, 2010 04:42 PM
by JLatham Go to last post
4 218
How to Round a Date to a Month by evoxfan
I have data such...
May 11th, 2010 04:23 PM
by James Perry Go to last post
2 172
Need suggestions on layout to report/pivot by Nadine
Does anyone have any thoughts on how to arrange this in Excel 2003: I have a group of invoice numbers. I have columns of inforamtion relating to the invoice:...
May 11th, 2010 04:07 PM
by Roger Govier[_8_] Go to last post
5 201
Putting "," in thousand separator by Radhakant Panigrahi
I have the below amount with me 50,862.82 73,820.42 107,363.57 1,156,634.06 In the above amounts virtually there is no “,” in between the numbers. I...
May 11th, 2010 03:52 PM
by Gord Dibben Go to last post
1 188
Difference between two times in seconds by Radhakant Panigrahi
hi i need a favour regarding finding out the time spent between two times in seconds. I need the current time like 12:35:45 PM in a cell A1 and after some...
May 11th, 2010 03:20 PM
by FSt1 Go to last post
1 210
Highlight cell colour by Charlene
In Excel 2007, when selecting different cells they are highlighted a light gray. How do I change that to a darker colour so that the selected cells are...
May 11th, 2010 03:18 PM
by Gord Dibben Go to last post
3 186
Preserving date format by Julia862621
Does anyone know how I can preserve my date format (dd/mm/yy) when doing a mail merge from Excel to Word? I would like to show either dd/mm/yy or 10...
May 11th, 2010 03:17 PM
by Dave Peterson[_2_] Go to last post
1 163
Text in cell missing when printing by Jesper Perregaard
Hi, I have a table with text in cells. Have used auto height and no text wrapping. Still, when printing part of the text in singular cells is missing. What...
May 11th, 2010 03:15 PM
by Gord Dibben Go to last post
1 230
Post New Thread


Display Options
Showing threads 1081 to 1100 of 139764
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 11:48 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.