Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
microsoft . public . excel . misc
This is a Usenet group - learn more
Find or start a Google Group about excel.
Group info
Language: English
Group categories: Not categorized
More group info »
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 258966  Older »
Description: Microsoft Office Excel newsgroup.
 

L2013 not running code from XL7, second posting 
  I have a worksheet with VBA code that has been in use for at least 12 years. It still works flawlessly in XL7 (2007). The code opens a folder which contains 24 photos (5M each) and places them in a worksheet along with their file name and date. The code even fails when I step thru the code, but seems... more »
By John  - May 20 - 3 new of 3 messages    

XL2007 code not working in XL2103 
  I have been using a VBA module for several years in XL 7 but crashes in 2013. Even when I step thru the code, it will crash about 50% of the way. The code basically inserts 24 photos into a spreadsheet for printing. It also includes date and photo ID. The code is attached. Please, any advice??... more »
By John  - May 18 - 1 new of 1 message    

Make peak values move to low value region - Peak Lopping - HELP! 
  Hi guys, I am trying to create a spreadsheet of daily energy use and have the ability to shift the max values to a period when the values are lower. Effectively I want to shift the peaks to trough regions. The spreadsheet will be used to model an energy usage profile by shifting the peaks to a... more »
By gottabarra  - May 17 - 1 new of 1 message    

Scientific Notation 
  Hello I am stuck in a wierd situation. I have a data, with which I creates a Pivot. Some of the value coming in Pivot are Zero, however some of those Zeros are though displayed as Zero, but when I press F2 to go into that cell they have values like 4,54747350886464E-13 or 2,27373675443232E-13.... more »
By Gaura215  - May 17 - 2 new of 2 messages    

Assigning a value to one cell based on the date in another... And then doing it again 
  Hello, I am working on a spreadsheet that is tracking additional vacation hours earned by employees as a result of perfect attendance. For every 3 months of zero issues an employee earns an additional 4 hours of paid time off. In column A I have listed the date of an employee's last incident... more »
By Kristyn  - May 16 - 1 new of 1 message    

prevent deletion of a workbook in a shared network drive 
  My company saves 2010 excel workbooks in a shared network drive. The problem is that everyone has access to them so sometimes they are mistakenly deleted. Is there a way to protect the 2010 excel workbooks so that they can not be deleted from the shared network drive? -- ivana
By ivana  - May 16 - 6 new of 6 messages    

IF statement help 
  Good Morning/Afternoon, Was hoping for help with a complicated (to me!) excel issue. Seen others use animals to try and explain there issues so will do the same, hope it doesn't come off as patronising! Basically I have reports sent to me with data, but if there is 0 quantity for an item it will not show up on the report.... more »
By J HART  - May 16 - 5 new of 5 messages    

Separting negative numbers from letters in cells 
  Okay I had to code data and possible values were as follows: -2c -2b -2a 99 1a 1b 2 I accidently put them all in the same cell however I need the letters and numbers in different cells (for example given |-2c| I would want to output |-2|c| with the straight lines being cells). I know there were... more »
By patatwork  - May 15 - 2 new of 2 messages    

Randomizer 
  I have been asked by my work to create a Lunch Buddy Program. I will need to enter employee names into a list and then have a randomizer select two people at a time until all names have been selected. Has anyone ever done this in Excel? If yes, could you explain how I would do this. thanks... more »
By CarolynWeaver  - May 15 - 2 new of 2 messages    

CountIf from multiple sheets in another workbook 
  i have 1 workbook with about 20 sheets, i need to search this workbook for a name in one column on each sheet. i made a list of the sheets in the 2nd workbook in column a. i tried this formula in column b, but i can't get it to recognize the cell in my formula: =SUM(SUMIF(INDIRECT("'[cfshows .xls]&A2'!U:U"),"Brown, Bob"))... more »
By JoshBrunz  - May 15 - 5 new of 5 messages    

1 - 10 of 258966   « Newer | Older »

XML