If you have a spreadsheet where column A is a list of names, for each name there are several data types (listed in column B) some of the data types are repeated. Column C contains the percentage for each of the data tpes for the whole thing. There are 300+ names, each with several data types and most where at least one data type is repeated. How can i easily calculate the total percentage for each data type, for each name.
View 10 RepliesI have 3 columns sports played then a winners column then a runner up column.
what formula can I use to search through the winner and runner up columns for a particula team say Hinuera (would do it for every team involved in the competition) and then get 2 lists produced of what sports they won and what they were runners up in?
I have a spreadsheet with around 250 tabs, all with a small amount of information on laid out int he same format. My question is can i collate this into one long tab?
View 5 Replies View RelatedI have attached an excel spreadsheet. I am trying to automatically calculate the data in the boxes, (Without using a Pivot Table) but have tried a variety of ways with COUNTIF, COUNT(IF()) and SUMPRODUCT, with confusing results. I managed to get a query to work with SUMPRODUCT, however it does not accept Wildcards (*) in the text reference. I has spent over 8 hours, and even tinkered with Pivot Tables, all without success - The data I would like to extract in the columns for summary is: Department * Logs <7 Days old *Average Log Age * Logs >7 Days Old * Average Log Age *
View 6 Replies View RelatedI have come across a problem which delivers 0 as a result, I am doing sumifs which i never had a problem before with, however I am trying to include a cell which is variable by using the & in collating data, the raw file also contains that criteria in 1 column so I have no mismatch.
View 5 Replies View RelatedI have built a timsheet template which I intend to issue to c.140 personnel in my company to fill in for the month of May. On receipt of these timesheets, I will save them all in one, specified folder. I would then like to consolidate the total number of hours worked by adding cell N53 from each timesheet received. Is there any macro/ VB script which can add the contents of a particular cell (N53 in this case) from all the spreadsheets contained within a particular folder?
View 2 Replies View RelatedThe link to my file is: [URL] ........
I am using excel 2003.
My query goes like this:
I need to find out "total lifted quantity"(i.e. the sum of 'first state lifted quantity'+'second state lifted quantity'+'third state lifted quantity') for each "state" for each "size" and each "grade".
However when I am applying a pivot table (as seen in Sheet1) it is not giving data in lucid form. I don't want to split the data for three states in three different tables (as seen in Sheet 4).
I have created a userform that allows input of information and then deposits the information on a specific sheet. I am looking for a way to have that information not only deposited on the specific sheet it is already set to but also to another sheet based on a selection made from a combo box.
here is my current
Basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc. However, everytime I put something new in Sheet 1, it just overrides the information in Sheet 2.
Basically I type in ticket sales in sheet 1, it calculates the prices and keeps a transaction log in sheet 2. But everytime I do a new ticket sale, it just overwrites the previous transaction witht he new transaction information. I've pasted my VBA below:
Sheet 1 VBA:
Code:
Option Explicit
'Form level variables - used in more than one event
Dim intAdult As Integer
Dim intStudentSenior As Integer
Dim intBalcony As Integer
Dim intChild As Integer
Dim sngAmountDue As Single
[Code] .......
Sheet 2 code:
Private Sub cmdSummary_Click()
'Declare Variables
Dim intCount As Integer
Dim i As Integer
Dim intAdult As Integer
Dim intStudentSenior As Integer
[Code] ......
Imagine I have 2 columns of information that look like this:
Column A
Column B
AS
Dog
AS
Cat
AS
Hamster
FT
Fish
These are my key columns. The letters are initials of people and the animals are the pets they're responsible for.
Now, I have 3 more columns that look like this:
Column D
Column E
Column F
These columns can go on for hundreds of rows.
What I want to do is pull out the information from columns D, E and F where the initials and pet match those in the key list, then paste that elsewhere (say to columns J, K and L).
So, for instance, the first entry would be copied across because, according to the key list, AS is responsible for a Dog, but the bottom entry for AS wouldn't because he was looking after a fish, and that pet isn't listed as one of his animals in the key list (Fish is listed alongside FT). Likewise, the entry for AH wouldn't come across because AH doesn't appear on the key list at all.
I used Excel to take inventory of the items in my store.
I have two columns that I would like to export into my point of sale program.
They are, "product code" and "inventory count". When I try to copy them into my pos system it won't work because I would have needed to hit the enter or tab key on the keyboard inbetween the two fields. So if I were going to enter it all by hand I would just type the product code, hit enter or tab and then type the quantity.
Is there anyway to make Excel export an Enter key press or tab key press inbetween the two columns? If I can't figure it out I will have to do it all by hand. (over 2000 items)
i need to counting some info from my excel, but i don't know how to set the formula for it. i have upload the example for your reference.
View 2 Replies View Relatedi was trying to see or figure out if there is a way to bring over information on a row from one sheet to another. I have a sheet with dates in column A and information going across to column h.
as an example i have row 1 that has date in A1, text B1, text C1, nothing in D1 but text in E1 all in Sheet 1.
I want to see if there is a formula that will say if it is todays date then grab that row and bring over the row with the cells that have data
i have workbook in which I have two sheets, one of them cotains colums with information and in the other sheet I have to create a Search box to retrieve all from any Contact number, of course it has to be based on contact numbers culumn.
example:
CONTACT_NUMBEROPPORTUNITY_TYPEQUARTERCON_TYPECONTRACT_TYPE_DESCRIPTION_LINECURR_CODE
379159OUTSOURCE201002C4PSMARTnet Onsite Premium 2x7x4USD
389859OUTSOURCE201002SNTSMARTnet 85xNBDUSD
379159OUTSOURCE201002C4PSMARTnet Osite Premium 4x7x4USD
388859OUTSOURCE201002SNTSMARTnet 85xNBDUSD
388459OUTSOURCE201002SNTSMARTnet 85xNBDUSD
388459OUTSOURCE201002SNTSMARTnet 85xNBDUSD
and in the other sheet I have to create a search box template that based on the contact number it will retrieve all other information.
I have created a form in Excel for my wife to be able to enter data. Once the data has been entered, a print is required, but, the form is large, it contains lots of formatting, a lot of "space" and a lot of color. I world like to (on another sheet) collect all the relevant text, without any formatting, space or color to produce a concise print.
View 2 Replies View RelatedI am working on a project that requires Other or Additional info to be available if I click on a specific item. For example, if I click on a person's name a message or pop up show appear with the person's address or any other information I might want to add. Is this possible in Excel or should I be using a different program?
View 1 Replies View RelatedI need to compare data on a spreadsheet to data that resides in SQL database. I have never done this before so before I start I wanted to ask a general question, what is the cleanest, simplest, way to go about this. I read that ADO is a good way to access SQL. I understand that ADO is one of the main components of MS universal data access specifications so it sounds like the right approach (and that ADO is replacing DAO).
In terms of application, all I want to do for now is pull data from SQL and write it to a worksheet in the Excel workbook. Other macro's will then operate on this data. Later I will want to write data back to SQL but I want to focus on the "get" part first. Are the statements SELECT; INSERT; UPDATE; DELETE examples of ADO coding?
Conceptually, the SQL team provide nightly tables of data; ADO retrieves some of that data by selecting it; The selected data is written to a worksheet within the workbook. Is this a good approach?
I am looking to pull information from certain websites and put them in excel. I'm not quite sure where to start. I have tried the search option but it is not returning anything.
View 3 Replies View RelatedI would like to know how i get excel to put information from say I7 into I94. i want it to be exactly the same information - and its not always a number. It could be a number, or text or a date?
View 2 Replies View Relatedi want to know the disks information like:-disks letters and disks size and volume and the free space in every disk in the computer i need to run a vba macro and to accept these information in msgbox
View 9 Replies View RelatedI have an existing table with times on the left most colum and diferent areas and events on the next 12 meaning a count of events and outcomes for 6 areas per hour. (X=QTY.throughputs; Y=QTY. Errors)
This would be the headers.
Time, XY, XY, XY, XY, XY, XY.
I need a formula to return the max "X" but also return the time it was recorded.
is there a vba code which I could use such that it will show me how much processing has be completed.
So basically the user first enters all the information required for the calculation(which is basically a bunch of records on which the processing is carried out), then they press a button which will start the calculation however currently the user has to keep on pressing the refresh button (ctrl+alt+F9) and keep on refressing until the results have been calculated then they are available to view.
I was thinking if it is possible that after the user click on the calculate button a form appears which will start the calculation and within the code it will automatically refresh the worksheet ('s) and then when a field within the worksheet (Status) changes to completed the form will then disappear.
I have a cell that has data like the following: ab 4111 / nw 2652 / ev 8741 up to 5 or 6 entries in the cell. If I just want 1 of these entries say the ev 8741 how can I have that be the only data that remains in the cell?
View 9 Replies View RelatedI have a worksheet containing records of data; (by record I mean 1 row of data), i want to move selected records from one worksheet to another, based on criteria. To start with some information to help. my first record starts at cell B6 and ends at cell U6.
the only problem is I don't know how to go about selecting my last row when the last row of data will change
i succeded to read a string of data from a textfile
String_Data= "EURUSD,20010103,000200,0.9506,0.9506,0.9505,0.9505,4"
Now i want to separate it so each informations goes to it respective variable
Market_= "EURUSD"
Date_= "20010103"
Hour_= "000200"
...
...
...
...
Volume_="4"
How can i separate the string information in individual variables using a macro.
I am unsure if this was answered already but I am having a lot of trouble. I am trying to find out if it is possible to count the number of entries in one column if it meets criteria in another comlumn?
Here is my problem: I work for a contractor and I am trying to find out the number of contracts sold(column J) by Mike (Column K). I have tried =COUNTIFS functions but these dont work. I know if I create 4 other columns with IF functions I can get the information but I have to imagine there is another way.
where is possible to get more detailed manual - reference - for using ADO in excel? Help in Excel doesnt content much information of ADO, I have tried to find other manual, but no results.
View 4 Replies View RelatedNeed little bit of information concerning excel. Where is the whiteboard located. Second, how can i highlight a cell or multiple cells. Finally, i need the Data Analysis Plus add-in. Any idea where can i download in from.
View 3 Replies View RelatedI’m looking for a formula which returns me the information from a row (for example in C2,D2,E2 etc.) to a column. So the information in B3=C2, B4=D2, B5=E2 etc.
Does anyone know how to do it with a formula?
I have spread sheet with 2 tabs (MASTER LIST & CYCLE COUNTS), on each tab I have 2 columns(LOCATION1 & DATE1 and LOCATION2 & DATE2) I need to verify if I any cell from LOCATION1 is repetead on LOCATION2 and copy the informacion from DATE2 to DATE1. then if I update the CYCLE COUNTS sheet I want the MASTER LIST update by it self.
This is the formula that Im using but Im having problems with the range..... =if('Master list'!$A2$:$A$15000='Cycle counts'!$A2:$A$15000, 'Cycle counts'$B&2:&B&15000,0)