I am trying to find some missing values compared to 6 base values. For instance, I have a sheet with some names translated to another language, I am trying to find the languages some names have not been translated too.
For example, if I have six languages, Arabic, Japanese, Russian, Chinese-Simplified, Chinese- Traditional, and Korean to compare too, I want to find any names that are not translated in certain languages.
Sample:
John Japanese John Chinese - Simplified John Korean Martin Arabic Martin Chinese - Simplified Martin Russian Ramon Arabic Ramon Russian Sam Arabic Sam Chinese- Traditional
As i am working on consolidating the Missing numbers manually, whether will it possible for making this automatic.
In Column "A" I have Multiple Duplicate Invoice Numbers and followed by the Different Transcation numbers in Column "B".
In Column "D" I have Each Invoice Numbers and in Column "E" Total Transaction Numbers i.e., no. of times each Invoice have Transactions.
In Column "F" No. of times we received the Transactions.
Here i need to manually need to update each Invoice's Missing Transaction number in Column "H" in single cell with comma separated to each Missing Transaction numbers.
I have two list of names, mostly duplicates. List in column B has about 30 more names than the list in Column A and I need to identify which names are in column B that are not in column A. Names are in exact same format since they were pulled from the same data base.
123569LOC23 is in one cell and I am trying to copy the "LOC23" to a new cell. However, the amount of digits vary: LOC23, LOC1,LOC15 etc all the way down the column.
This problem has come up fairly frequently lately, and I'm not sure how to fix it, or if this is by design...but in Excel 2003 I can't seem to do a "Find and Replace" based on the value of a cell. I can do a find, based on cell value, but the moment I change to the replace tab, the "values" and "comments" are missing from the "look in" dropdown.
I've only noticed this when I'm trying to replace on a filtered list, so I'm not sure if that is part of the issue.
Perhaps an alternative way of arriving at the same goal. Basically I have a worksheet with a number of filtered columns. They are filtered just right, using custom filtering, and so I do not want to undo the filters. In some columns I have formulas that are returning #VALUE! errors. I'd like to replace all of these cells with NA.
My main sheet has the results of a competition in rows 1-100. 75% of the results won't count for the jumpoff ( its a horsey competition) and I want to automatically copy the successful details to another sheet. I've worked out how to to omit the unsuccessful results by using an IF statement ( IF cellx is > x then copy ) but I still end up with 100 rows - with 25 results and 75 blank rows. How can I copy but compact it down to 25 rows.
As a second question I need to sort the results. I know how to do a manual sort & I even worked out a macro so one keystroke can do the sort. It woruld be better if the sort would be automatic whenever there is a change in the scores.
Does anyone know why, when I copy a Worksheet (right click Worksheet > Move or Copy > Create a copy), Excel occasionally fails to copy across the embedded objects contained within the Worksheet (e.g. Charts, Command Buttons, etc.)?
This is very frustrating, and I'm wondering whether it's the way my Worksheet is configured, or whether this is a known bug.
Find Multiple instances of Numeric Criterion in Row & Return To a Single Column.
I have a Dynamic Named Range "Data" spanning 10 Columns and many Rows. Each Row may contain duplicates of the Numeric Criterion.
I would like to find ALL instances of a specific Numeric Criterion across each single Row in the Dynamic Range "Data" and have the Results returned to a New Sheet in a single column.
NEW Sheet: The Numeric Criterion is housed in G5. The matched criterion should be returned to the New Sheet starting at G7. Duplicate instances in the same Row should ALL be returned to the same cell in Column G on the New Sheet.
Sample Data Layout: Columns I J K L M N O P Q R Row No.76 1 0 1 1 0 1 1 1 0 1 Row No.77 2 2 3 2 1 2 2 0 0 0 Row No.78 3 3 3 3 3 0 3 0 3 0
Scenario: Looking for Numeric Criterion 1 (one).
Expected Results - New Sheet: Row No.7 Column G (Cell G7) 1111111 Row No.8 Column G (Cell G8) 1
In Row 76 of the Sample Data ALL seven Numeric Criterion of 1 (one) should be returned to the same cell G7. In Row 77 of the Sample Data there is only one Numeric Criterion of 1 and it should be returned to cell G8.
I need find consecutive Numbers in a singles Cell but each numbers have a leading zero and "-" (Dash)
My problem is that the UDF that i found on this forum, is for numbers with out leading zero with comma ",",
So even if change the "," by "-", still getting a error Because the Code is designed to Read numbers Formats different than mine..
My Numbers are located in Cell G12 (down), and the message that i need to show in the cell result is :
If Found : 0 Consecutives --> 0 2 Consecutives --> 2 3 consecutives --> 3 4 consecutives --> 4 5 consecutives --> 5 2 Set of consecutives --> 2S
Example of 0 consecutives --> 01-04-07-12-25-30 Example of 2 consecutives --> 01-02-07-12-25-30 Example of 3 consecutives --> 01-02-03-12-25-30 Example of 4 consecutives --> 01-02-03-04-25-30 Example of 5 consecutives --> 01-02-03-04-05-30 Example of 2 sets of consecutive s --> 01-02-07-12-25-26
BTW my numbers start on Cell G12 down.. ______G12_______ 01-02-03-20-21-25
I have a macro which scans column "AV" in Sheet1 and if a particular value is found it will copy certain cells from that row and paste them into Sheet2 on Row 10 starting with column "E".
With the current code I only paste a single instance, if the value is found more than once I only have the last one pasted. How can I best set this up so it will paste ALL found value results within Row 10?
The four copied results do not have to be in separate cells, it is actually best if the cells are combined. On Sheet2, cells E10-H10 can also be setup to have the data pasted across all four cells and that way Row Height AutoFit would take care of expanding the row's height to accommodate the possibly of having four or five sets of results being combined together and pasted into E10.
Is this even possible using a macro? It is currently being done using a Word document but I am wanting to automate the process and try to handle all the data sorting within Excel, if possible.
Sub Number() Dim colSearch As Range Dim celVal As Range Dim celRow As Range With Sheets("Sheet1")
see the attached sheet. It already has some example....I need the result of the addition in the cells of column F, at the side Say column G, in the coressponding row. e.g for cell F9, I need the result in G9, and so on. For testing, step 1. Select M+R in Col "TOI", enter some value in the pop up. step 2. Again select M+R in "TOI", enter some value in the pop up. the Col F will have some additions (e.g 1+2), for which I need the result in the corresponding next column. i.e col G.
I'm trying to validate the data entered into a series of cells each cell can contain a different set of data but the value N/A is also permitted. For example:
Cell A1 could contain a date from 2013-01-01 thru 2013-12-01 but the value N/A is also valid Cell A2 could contain a decimal from 0.01 thru 302502.23 but the value N/A is also valid Cell A3 could contain an integer from 3 thru to 9000 but the value N/A is also valid
When the acceptable values are entered then I want to be able to carry on otherwise I want to pop up with an error.
I have an assigned value of 10 to each checkbox that is checked. If the checkbox is selected I want to automatically sum the totals in a cell on my active sheet. Checkboxes are activeX placed directly on a worksheet. I currently have a work around but considering the number of checkboxes I have, coding is going to be a nightmare as I would have to code each one separately. Right now I am summing each box on another sheet and linking the summed total back to active sheet.
[Code] ....
I would like to do all check boxes with one code and sum the total in the active sheet in cell "I7". The set of checkboxes is 1 to 26.
I am looking to produce a formula that shows if a number is "found" or "not found".
I have list of over 1000 numbers in one column (1 number per row) . I am trying to identify if those values are present in a range of numbers from another worksheet(also in a single column). My challenge is that the range of numbers that I am looking in has multiple values, separated by commas in a single cell. Looks like it was from an Access data dump.
I have a series of columns (L - X) each representing a diagnosed disorder (Dx), coded as binary, with 1=Positive Diagnosis (Success). The reference cell contains diagnostic codes; for each respective Dx column I need a 1 or 0, obviously. Each Dx category has a range of values (Dx codes), so I need to write syntax that reflects this range. For example, =IF(A1=>141,AND(A1=<239.99)),"1","0")
In other words, if cell value is 141 through 239.99 then return 1, else 0
Would it be something like this: =IF(AND(A1=>141,OR(A1=<239.99)),"1","0")
I am building a marketing dashboard that shows the effectiveness of two campaigns based on where the campaign has been deployed (website, email, facebook, twitter, google+ etc.). In each campaign I have a checklist (using developer ribbon) with these different dimensions.
I want a formula that checks the checklist, identifies all the boxes that are unticked and returns them in a single cell. The cell would read:
To increase traffic to the Shampoo campaign (Campaign A), expose it to Google+ and Facebook as these channels generated 578 and 2009 visitors respectively for the Makeup campaign (Campaign B).
I already have it working for returning a single value with the following formula but need it to return multiple values.
=IFERROR("To increase traffic to the "&B4&" campaign, expose it to "&INDEX(L4:L10,MATCH(K5,M4:M10,FALSE))&" "&"as"&" "&"this channel generated "&VLOOKUP(INDEX(L4:L10,MATCH(K5,M4:M10,FALSE)),L26:N31,2,FALSE)&" visitors for the "&D4&" campaign","")
I am building a marketing dashboard that shows the effectiveness of two campaigns based on where the campaign has been deployed (website, email, facebook, twitter, google+ etc.). In each campaign I have a checklist (using developer ribbon) with these different dimensions.
I want a formula that checks the checklist, identifies all the boxes that are unticked and returns them in a single cell. The cell would read:
To increase traffic to the Shampoo campaign (Campaign A), expose it to Google+ and Facebook as these channels generated 578 and 2009 visitors respectively for the Makeup campaign (Campaign B).
I already have it working for returning a single value with the following formula but need it to return multiple values.
=IFERROR("To increase traffic to the "&B4&" campaign, expose it to "&INDEX(L4:L10, MATCH(K5,M4:M10,FALSE))&" "&"as"&" "&"this channel generated "&VLOOKUP (INDEX(L4:L10,MATCH(K5,M4:M10,FALSE)),L26:N31,2,FALSE)&" visitors for the "&D4&" campaign","")
I have a single cell with 4 values in it all separated by commas and i would like to pull out each one separately. The number of characters in each value changes.
I need to count the number of values entered into a single cell seperated by commas for record keepin purposes. I would prefer not to use a macro since I am not an expert, but will if i must. Here is an example of what i am talking about:
User A will enter "109,108,107,106" into a cell in Column A
At the bottom of column A the Total will read 4.
Now User B enters "110,111,112,113" into the next cell in Column A
Say i have a range A1 to A10 that contains these numbers
101 102 103 104 356 106 225 107 108 109
I need some code that will help me find the next highest missing number in the value range of 101 - 199 in that range A1 to A10. In this case it would be 105
I have a file with approx 3600 rows. In Col B there is a 13 digit EAN-13 code. I would like to find out which numbers are missing. I have to compare each cell from top to bottom in the B-column to the cell below and find out if there are some missing numbers. If the numbers are incremental then goto next cell. But if there's a gap in the numbers then it should insert the missing numbers with an increment of 1. I think the logic statement should look like this:
i = 1 For x = 1 to last row If the gap between B(i) and B(i+1) < 1 then Insert a row and put the missing value in the cell on the new row. Endif i = i+1 Next x
The comparison has to be made from the 5 digits in place 8-12 in the code.
Here's an example (i've dimmed the digits that shouldn't be compared):
As you see there's a missing number between the third and fourth row. Here the value should be 733098592074 + the checksum that is a bit tricky to calculate. Between the fifth and sixth row there are four missing numbers that has to be filled in. The checksum is OK to leave out at this moment. The important thing is to get the 5 digits.
I'm having a column called "Body". Each cell in this column contains a huge amount of text. I want to select automatically certain values from that text and copy them into other cells. This image will explain what i mean:
I tried to work with the function MID but that doesn't work because the values don't have a fixed position. They don't start always at the same character number.
How to have a validation list (drop-down) from a single-cell in which values are separated by a comma.
Example I have.
I have a wine list which have many categories of which
COL A / COL B / COL C Wine Name / Wine Producer / Vintage
I wrote a VBA code to look-up duplicates names and give the producers that make them. The names of the producers will be in an invis cell as Comma Separated Values.
For example: Wine 11 is made by producer X and Wine 11 is made by producer Y. I will have X,Y in a cell which need to be in a drop-down menu when Wine 11 is selected.
I got everything done. The only issue is to get the list. The problem is that the drop-down list shows X,Y as a single component and not as 2 drop-down components. If i were to write down X,Y in the validation list tab, it will show it as 2 components but referring to the cell doesn't.
