Advertisement

1 - 10 of 278 containing alltags:("MS Excel") (0.003 seconds)
Hi All, I have data like what is presented below. I want to group by col1. before ======== col1      col2      col3 1      2      3 1      2      4 2      3      5 2      4      5 3      5      6 7      8      9 7      8      9 After ======== col1      col2      col3 1      2      3...
Zones: Spreadsheet SoftwareDate Answered: 06/10/2008 Grade: A Views: 0
Hi I have a column with dates and I'd like to have "1" in other cell if date is equal to 31st of Dec (31/12/yyyy) I wrote sth like this to give u a clue about what im talking :) If ThisWork...
Zones: MS ExcelDate Answered: 01/16/2008 Grade: A Views: 22
Hi I have a string, it is in text format, I'd like to take 4 first characters from the left (this 4 characters are always digits), increase by 1 and add back to the some string. I do it in MACRO...
Zones: MS ExcelDate Answered: 01/17/2008 Grade: A Views: 0
In column A for a worksheet called "Accounts_Status"  I have several columns called account, product, inventory_count, inventory_age.  Within these columns I have some conditional formatting.  I wi...
Zones: MS ExcelDate Answered: 01/27/2008 Grade: A Views: 0
Hi I have a problem like this: I have a sheet with rows and sometimes I have 2 similar records but only with diffrent volumes of stock. Id like to add the volumes and delete only one with added ...
Zones: MS ExcelDate Answered: 01/22/2008 Grade: A Views: 0
Please help with this question: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/viewOpenZoneQuestions.jsp?taid=604 The most recent comment from the ...
Zones: MS ExcelDate Answered: 01/28/2008 Grade: A Views: 0
Good afternoon Experts, On a VBA UserForm how can I: 1. Place OptionButtons within their individual Frames and yet keep them within the same Option group. In other words when I select an Opti...
Zones: MS ExcelDate Answered: 01/29/2008 Grade: A Views: 13
I have a list of companies and I need to figure out a way to quickly pull out or highlight the companies that are part of the Fortune 1000 list. So I am thinking I'd have one sheet with my list and...
Zones: MS ExcelDate Answered: 03/28/2008 Grade: A Views: 37
Hi I have a Pivot Table. It has been organized by months. I have 12 months but for one month there are no data so the column with this month doesnt appear, I have 09/2008 changing to 11/2008. Ho...
Zones: MS ExcelDate Answered: 02/19/2008 Grade: A Views: 0
Hi,  Here is the example. I have some value in Cell B5 of my spreadsheet.  I have other values starting B6 to B20. I want in every corresponding column to be B# - B5. So for example C6 should be ...
Zones: MS ExcelDate Answered: 02/23/2008 Grade: A Views: 10