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
deleting blank rorws by VRaybandb
I imported some information from a web page and when it loaded it has huge amounts of blank rows, how can I delete these without doing each small bunch of...
December 10th, 2008 05:58 PM
by Gord Dibben Go to last post
6 75
Subtotals every "X" number of rows by clh
Is there a quick, easy way in Excel to do subtotals ever certain number of rows? In my case I need subtotals every 15 rows. Oh, this is Excel 2003. I know...
December 10th, 2008 05:54 PM
by Sheeloo[_3_] Go to last post
3 89
Compare two Worksheet and copy the diferent rows to other by CC
Hi I'm try to wright a VB code to compare two sheets sheet1 call "Old data " and sheet2 call "New data" and copy the intire row where a diference was...
December 10th, 2008 05:48 PM
by CC Go to last post
0 108
Vlookup to create a list from a larger list by Terri
I have a report with all our active projects that I can export into Excel. The project number is in column A and the Project Manager is in column F, what I...
December 10th, 2008 05:38 PM
by Pete_UK Go to last post
3 126
SUMIF by Neil Pearce
Dear all Please refer to link. http://www.savefile.com/projects/808719857 I need to SUMIF based on two references. Any ideas? Yours in appreciation, Neil
December 10th, 2008 05:36 PM
by Herbert Seidenberg Go to last post
2 96
COUNTIF across different spreadsheets by Kat
Does anyone know if it is possible to utilise the COUNTIF function across 2 or more different spreadsheets... I keep getting a value error when I try....
December 10th, 2008 05:36 PM
by Kat Go to last post
2 119
excel templates by Michelle
I have a work created template that I would like to have everyone on the network see and use. When I copy the template into the directory where all the...
December 10th, 2008 04:59 PM
by Michelle Go to last post
3 83
Regarding Arrays by Raj
Hi Here is the excel data how my data is distributed. Incident Description Status Date logged 313 XXXXX ...
December 10th, 2008 04:51 PM
by Max Go to last post
5 82
Problem with Column header ID being 1 2 3 etc instead of A B C etc by MarcoKoenders
For some reason my column header Id show and has changed into numeric 1 instead of A, 2 instead of B, 3 instead of C. When now selecting a cell like C5 the...
December 10th, 2008 04:49 PM
by Bernard Liengme Go to last post
2 109
Excel UNC Path opens in Explorer by alc8833
Currently when I put a UNC path in Excel and click on it, the Path opens in Microsoft Explorer. I would like the link to open up in "My Computer". If I use...
December 10th, 2008 04:43 PM
by alc8833 Go to last post
0 82
Excel selects more extra cells by DGR
When clicking on cells to select on a worksheet, Excel automatically selects either extra lines or cells. Then when I click above or below, it keeps the...
December 10th, 2008 04:43 PM
by Mike H Go to last post
1 89
Between two dates by jen-chi
I have three dates on the spreadsheet and I need to know if the third date is within the parameters of the first two... Column J = 03/21/07 (start...
December 10th, 2008 04:25 PM
by RagDyeR Go to last post
3 96
Transpose Column to Rows by Pai
I have around 1600 Name along with company name,Address1,Address2,City,State,Pincode For Ex: Mr.hardeep Kanwar Bi/200 Yamuna Vihar Dehi 110053
December 10th, 2008 04:24 PM
by Pete_UK Go to last post
3 79
Excel 2007: Filename.xls is locked for editing by another user by TERRAUSC
We have a shared file that ocassionally give this error when someone attemps to open the file. Sometime we can overrirde by using the read only option but...
December 10th, 2008 04:19 PM
by [email protected] Go to last post
1 101
Copy/Paste Macro using large amount of Data by Nikki
Hi All: Can you please tell me if there is a macro that will copy at each change in Customer name and paste into a new worksheet. For example, if I have over...
December 10th, 2008 04:12 PM
by Nikki Go to last post
2 100
insert feilds from word document into excel by Shi Gharib
Hi, I hope someone could help me on this one. 1- I have around 150-200 files (adobe acrobat, MS word, excel) that contains different informations. 2- I have...
December 10th, 2008 03:58 PM
by Bob I Go to last post
1 71
Massive Find and Replace by Brian D
I have 3000 codes in column A1. I have 3000 company names in column A2. I have a seperate worksheet that has column F with random codes. I need the codes...
December 10th, 2008 03:58 PM
by Brian D[_2_] Go to last post
3 80
Getpivotdata problem by Al
Hoping you can help. I have a Getpivotdata function as per below that successfully returns the relevant data for all of my records with the exception of...
December 10th, 2008 03:57 PM
by Al Go to last post
2 95
how to select and count from a range of data by Ajay
I have 3 data sheets: Sheet1, sheet2, sheet3 From Sheet1 a value V1 is taken and looked up in Sheet2 another value corresponding to V1 ia taken say V2 (I...
December 10th, 2008 03:36 PM
by Ajay Go to last post
2 84
Regarding the Arrays by Raj
Hi Here is the excel data how my data is distributed. Incident Description Status Date logged 313 XXXXX ...
December 10th, 2008 03:26 PM
by Pete_UK Go to last post
1 73
Post New Thread


Display Options
Showing threads 29921 to 29940 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 02:41 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.