I have to have to have 2 criterias for it to pass before the items are counted
I have 2 columns of data.
1 being a list of clients names, and 1 being if the Connection/Abandoned
Client Column is colum "F"
Connection/Abandoned is colum "J"
I need to count how many Connected and how many abandoned for each client
So if "F" equals "BPS" and "J" equals "Connected", then count.
I have a column with (potentially) multiple values in, heres an example:
Marketing Specialism
Commercial, Multi-channel, Loyalty/Retention
Analytics, Partner
Analytics
Commercial, Analytics, Segment
[code]....
What I need to be able to do is count (and then chart) the number of each value, irrelevant of whether it appears with another value in a cell. e.g.
Analytics, Parter - Would count 1 Analytics and 1 Partner
Analytics - Would count 1 Analytics
I know there is a formula where I can specify the value to count, but as the column has so many different values I would have to write a formula with each separate value, this would take a long time.
I have a listbox with 8 columns. Multiselect is enabled, and it must stay this way. As part of my program, after the user presses a command button, I need to use the row indexes of the selected rows in order to copy the selected information into an array which is then placed in a different listbox, and then delete the items from the original list. Pseudocode of what I want to do:
[Code] .....
But my understanding is that .ListIndex does not work this way with multiselect listboxes. I've tried searching for a solution for a while, but I cannot find one.
Let's say I have one column of;
1
2
3
4
5
6
7
8
9
What is the most efficient way to change this into '3-columns & multi-rows' like this?:
1 2 3
4 5 6
7 8 9
The actual list is a lot longer and numbers are not in order.
I have multiple rows within a cell separated by Alt+Enter, and would like to combine them as follows:
Desired Result
First
First
Name
Name
First Name
First Name
Im trying to construct a nested Countif statement. I need to count the number of instances that "Project" appears in Column O AND "TS" in Column N. The range is in another in Sheet2. and the summary in Sheet 1 where I want to have the Countif(AND...??? statement Example Counif(Sheet 1 Column 0 contains "Project" AND if Column N Contains "TS"
View 2 Replies View RelatedI want to sum data in COLUMN C that is related to COLUMN B if the COLUMN F is blank.
View 10 Replies View RelatedI have a spreadsheet which have data auto inported. (thanks to previous help on here). I have now come up against the next problem.
I wish to make the mark up variable depending on 5 options (workings I13;I17)
the choice is selected in column b after the data has been inported
then down on Rows 75 - 79 i have the totals of my choices.
Unfortunatly i do not know how to do a variable sum
I have attached a copy of the workbook.
What is the best method for searching and replacing within a string when the string to be replaced could be say 1 of 10 options and could appear in any position within the string ? To make it easier let's say wherever those sub strings appear they are to be replaced (ie none to be left behind), and lets say they are all to be replaced by another character -- specific to each string being replaced.
Example:
Say I want to replace any digits in a string, to be replaced like for like as follows:
0 -> a
1 -> b
2 -> c
3 -> d
4 -> e
5 -> f
6 -> g
7 -> h
8 -> i
9 -> j
Sample strings:
Luke is 0 Donkey
Luke is 0 Mul4
0nd Luk4 is not very cl4v4r
Luke can not h40r very w4ll.
etc...
I am trying to sum the error points of staff in their work done based on a specific time frame. For example,from 4.00pm to 4.30 pm as per the attached. I tried sum product but did not work. Is there an addition formula that I need to use when incorporating time ?
View 6 Replies View RelatedIn the attached file I managed to sum up the Quantities per Material & Category. The Original DATA is presented in columns A:E. The requested results/Formulas are at Cells B2:B4. My Question is very simple: Is there a way to sum up the Quantities WITHOUT the Help-Column G !? If so - how ?
View 9 Replies View RelatedI have a 2-column employee file. Column A has the employee id and column B has the manager's employee ID. The reporting layers can get pretty deep. In this example, there are 6 layers of reporting. For example, Employee id 1200 (which is not in column A) has 2 employees. One of them (1712) has several employees, one of whom (1680) has employees reporting to them and so on for several levels.
Is there a way in Excel (2003 or 2007) to summarize the reporting structure? For instance, I need to know all of the employees that report up through emp id 1712 - not just that report directly to 1712, but all those under 1712's tree.
formula to calculate the commission based on 9 cases each case is subjected to 4 differant arguments.
here is the formula for the first case (the answer if true 1.4) & the last case( if all the casses are fails it should show 0.6) u will find it in cell K5
=IF(AND(E5>=20,H5=1,I5>=80,J5>=80),1.4,0.6)
this is only 1 case HOW can i calculate it basd on 9 casses??
I am currently using the formula below to lookup a name and its corresponding code. I type the code into cell A13. The name is fixed at B1. This formula then finds the name (B1) in a table and matches the column header of the code which I type into A13 and returns a value. This allows me to type in different codes and quickly see the value corresponding to the name. I also want to be able to type the coding into A13 and be able to see a listing of all of the names attached to that coding.
VLOOKUP(BETA!B1,MAINTABLE,MATCH(BETA!$A13,MAIN!1:1,0),FALSE)
is ther away of usin 1 button to open any 1 to 46 worksheets
i know i can make a button to open a sheet with the command
sheet2.activate
but this means i would have to have 46 buttons on the fron page and thats to many
Usually when I select a number of cells with my cursor excel adds up the cells and shows a total on the bar. It's stopped doing this now and will only show the 1st cell showing "max=No"
View 3 Replies View RelatedSee attached example for reference - I am trying to calculate an average if it meets 2 conditions, i.e, calulate the average for the Lead Time column if it is a Bag and On Time. Hope you guys can come through as always!
View 4 Replies View RelatedHow to draw multi Arc Shape in Union group Locks Like (Smiley Face 11)
View 2 Replies View RelatedI know that there is an easier and shorter way of doing this;
View 6 Replies View Relatedmulti cell sheet name rewrite this code as it fails at the
View 2 Replies View RelatedWhat i would like to know is, In the code im using to make a phone call from a userform the varibles are set in each and every sub. It all works well though could they be compressed into only being used once like an option variable or somethink like that.
i know that more that one variable can be decleared at the same time of the same type "dim x, Y, z as long.
Can i have the caption of a multi-page tab caption change on the result a given cell?
i.e. in the attached example i would like page 1 to be the result of B2.
I am not grasping how to setup a multi column listbox (2 columns).
View 13 Replies View RelatedI have a database that is setup and I want to add a ListBox to the userform and I know how to do that and add all the listbox entries.. my trouble is how do i save the selected entries(multiselect) to sheet and load them to the form (what was selected) using what i have below?
HTML ListBox1 = cells(n,5).value
and to save
HTML cells(n,5).value = ListBox1
I've got a column with client codes (col. B) and another one with material codes (col. C). Both columns mix numbers and text. First condition: If cells in "B" column equal a specific code ("DA2")
Second condition: AND If the cells in "C" column start with a certain pattern ("30") followed by some other pattern (four random digits, a dash, and two or three more random digits). THEN a new cell should say "T1", Else it should just copy another cell.
My company nature is real estate
I need to record every agents closed deal.
For example i have agent A, B, C & D
I have a worksheet for each agent.. but I need a overview sheet for all the deal closed.
Is there a way that if I update the overview sheet and setting the formula in A, B, C & D worksheet that when there is their name appear in the overview sheet will record in their own sheet as well, so I don't need to update the overview sheet and individual agent sheet.
I have been tasked with doing a retail over/short Spreadsheet. The spreadsheet will be 13 tabs with 12 being the months and the 13th being the yearly summary. On each sheet will be the cashiers name.
I need to be able to script the addition of a new cashier and have them added alphabetically to all 13 sheets and at the same time keep all currently entered information with the appropriate person
End user only wants to use Excel
I have to prepare files of over 100 tabs in each. I have a list of numbers on a spreadsheet that must be entered on each tab. Am I making myself clear because I tried to do it manually and it's no joke?
View 1 Replies View RelatedI'm trying to make two multi select listboxes in excel. I have tried I myself, but I know the excistence of VBA only since one week .
In sheet1 I have a number i.e. 50 in "A1" . First I want to make a list of this number, so cell "A2" = 1, "A3" = 2, .... "A51" = 50. This range has to be variable since the number can be 1 but als 100.
Then I want to populate ListBox1 in sheet2 with the list from sheet1. Next I want a second ListBox (ListBox2) and two buttons ("Add item" and "remove items") to move items from ListBox1 to ListBox2 and back.
Finally i want the selection that is made in ListBox2 to be put in sheet1 in a specific column (let's say C) where "C1" is the first selected item from ListBox2 "C2" the second and so on. This range has to be variabel since the number of selected items is not known.
I have the following function. the problem with this excel is i give it "C:" as directory, it search only one level of sub folders i.e it will search the filename in
C: est
C: est3
It does not go deeper. i.e it wont look in folder that is for example
C: estanotherlevel
C: est3anotherlevelmylevel3
How to modify my function so that it goes to the deepest folder. is there a way to do it?
Function GetFile(directory As String, filename As String)
Dim FSO As Object
Dim fldr As Object
Dim subfldr As Object
Dim file As Object
Dim fullname As String
[code].....