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...
http://www.experts-exchange.com/Software/Office_Productivity/Spreadsheets/Q_23468267.html
Hello, I have a basic question about Excel. Now, I have Sheet1 and Sheet2 and when I put a value at A1 in Sheet1, I would like to show up the same value at B2 in Sheet2. How can I get it?
BestRega...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/05/2008 Rating: 9.8 Views: 0
I want to convert an Excell sheet to MS Access.
Looking in the Help file it said:
Go to the menu Data and take the option 'Convert to MS Access'
Unfortunatly I do not have this option in my Data me...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
Zones:
MS OfficeDate Answered: 06/07/1999 Rating: 7.0 Views: 0
I need to write a small app in VB version 6 to take an MS Excel spread sheet and than upload it to an SQL Server 2000 DB.
I have about 5 years experience working with VB but I am rusty(Have done...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_21077531.html
Zones:
VB DBDate Answered: 08/05/2004 Rating: 7.6 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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/16/2008 Rating: 8.8 Views: 0
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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/17/2008 Rating: 9.4 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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/27/2008 Rating: 8.6 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 ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/22/2008 Rating: 9.4 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 ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/28/2008 Rating: 9.6 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...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/29/2008 Rating: 9.4 Views: 0
