A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : New Users to Excel Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
dependent, multiple variable, drop down list by narcosmurf
I am trying to setup a form that has several drop-down lists that update the subsequent drop down until a final result is listed. To simplify it, I'll...
September 25th 13 06:45 AM
by Claus Busch Go to last post
2 724
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range by trader1011
Hi, I need to aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the hourly range. So, basically if I have 10 observation 7 days, I want to put them into the...
September 20th 13 04:49 PM
by trader1011 Go to last post
0 694
Removing letters from cells by Quilp
I have a column where the cells contain V11, C139, D27 etc. I need to strip the letters out so that I can apply the MAX formula to the entire column. The...
September 18th 13 10:14 AM
by Quilp Go to last post
2 659
Custom Header Help/Question by Jess[_3_]
I have a custom header in my spreadsheet that I would like for it to only show up on the first page of my spreadsheet, not all of the pages. Is there a way to...
September 16th 13 11:48 PM
by Jess[_4_] Go to last post
2 557
Sorting rows by Quilp
I have my recorded music collection catalogued in a worksheet where column A shows the date when a new addition to my collection is added, column B shows the...
(Multi-page thread 1 2)
September 15th 13 08:53 AM
by Quilp Go to last post
17 1,334
Scatter graphs, excel 11 mac user by sam42
I'm trying to create a scattergraph with text values in columns (5 columns) along the x axis and numerical values along the y axis (with range from 60-1400)....
September 6th 13 12:28 PM
by sam42 Go to last post
0 576
Question
Vlookup to return 0 instead of NA by CYA30
I am hoping someone can help me.... I am currently building out a spreadsheet and have successfully (I hope!) used this formula...
August 30th 13 12:49 AM
by joeu2004[_2_] Go to last post
1 5,632
Is it possible to add +1 to a specific cell by Fooz
What I am trying to do is save me alot of time down the road. Currently I am using a standard +1 macro to change an ACTIVE cell. What I want to do is design a...
August 27th 13 07:17 AM
by Fooz Go to last post
0 635
Excel hierarchy by WINDSEAKER1
Gm Trying to find information or example of creating PM (Preventive Maintenance) Hierarchy into a spreadsheet. My main goal will be to establish working model...
August 22nd 13 04:55 PM
by WINDSEAKER1 Go to last post
0 561
Lightbulb
Countif by HunorR
Hello, I need a little help whit my project.I have multiple sheets and every sheet has multiple tables. I have found the way how to count so me names in my...
August 22nd 13 10:11 AM
by HunorR Go to last post
2 500
Question
Macro Help by lostgrave2001
Hello Could anyone show me how to change the following macro to activie sheet/tab rather than having to create a new macro for every tab. Sub runlocal() ' '...
August 21st 13 01:39 AM
by joeu2004[_2_] Go to last post
7 1,227
Thumbs up
Help creating new functions for Excel 2013 by Jschock
Does anyone know how to create new functions? I am trying to write a formula that will return the Date Modified for another cell. Does anyone know how to do...
August 20th 13 01:25 AM
by Stan Brown Go to last post
4 1,137
Help needed for inserting a row. by [email protected]
I am using Excel 2003. I have a spreadsheet that has 2 Heading Rows. The first row entries cover several columns. The second row covers individual columns. The...
August 17th 13 07:40 PM
by janmelnick Go to last post
1 677
Question
Goal Seek with variable Set Cell by raith99
Hi, I'm relatively new to excel and would appreciate any help with the following problem. I'm working on a pensions spreadsheet and need to work out income...
August 8th 13 09:47 PM
by joeu2004[_2_] Go to last post
1 774
Merge row by ID by jc.yin
I've got a set of columns like this in excel: ID sizeAndColourAndSku_Value ...
August 8th 13 03:06 PM
by Ron Rosenfeld[_2_] Go to last post
1 622
Thumbs up
1 Attachment(s) Need Opinion by Asrar Ayub
Hi All, I have a list of data in excel, which i want them in separate cell. Example: Cell A1:*Iowa Department Of Transportation (crossroa, 0103, Current)...
August 6th 13 08:15 AM
by Claus Busch Go to last post
1 592
1 Attachment(s) fill range with dates based on month by flyinghigher2011
hi all i have a cell N3 where i put lets say Aug13 and i have cell that hopefully put in 1 aug 2013, what im after is this. if N3 is August or aug13 then i...
July 31st 13 06:40 PM
by flyinghigher2011 Go to last post
0 586
Smile
=min =max by Sneibel
=MIN(5,O19*0.1) I need this to also function as a =MAX (1,O19*0.1) I need to multiply the $ amount in O19 by 0.1 but if that number, when multiplied, is...
July 26th 13 08:02 AM
by Claus Busch Go to last post
1 622
Consistent Sheet column header rows by Walter Briscoe
It took me some time to find that I have broken a hidden constraint in a file that I have: I have many sheets which need to have consistent column titles. In...
July 26th 13 07:34 AM
by Walter Briscoe Go to last post
2 637
Water meter readings by IVjcsud
Hello I need help if you can with inputting and calculating meter readings. This would help cut down on multiple inputs manually. Any help would be greatly...
July 23rd 13 12:18 PM
by Claus Busch Go to last post
1 736
Post New Thread


Display Options
Showing threads 81 to 100 of 13664
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 On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:39 PM.


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