xxx

Hi, I'd like to have a vba code for that problem. If column "R" contains whether "xxx" or "yyy" or "zzz" then delete from the specific rows thw following cells: U:AD and AV:BE and BW:CF and CX:DG. So, for example in column "R" it finds "xxx" in row number 15 and "yyy" in row number 22, than...

Hi Gurus, <tbody> Emp name father name mother name Guardian name James XXX XXX XXX david XXX </tbody> i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement...

Good Afternoon All... I have a column with names and SSN's, as such John Doe: XXX-23-6789...I want to extract "XXX -" and be left with "John Doe: 23-6789". Thank you kindly Benny Torres

Hi Everyone, I am facing trouble with data for which I get list of files with specific fields. I need to scrutinize and form it in table format. Eg Input Name: XXX Age: YYY .. Name: WWW Age: TTT ... Output NAME Age XXX YYY WWW TTT......

I have an excel sheet where equally spaced columns starting from AD (AD, AI, AN, AS, AX, ...) contain a string. The string can be anything from a set of 4 pre-defined strings. Requirement - Find the string that occurs most frequently in these columns. Example AD -------- AI ---------- AN...

I am writing a macro to delete all rows of a ListObject table not matching a specific value, so that the resulting table is left only with the value I want to keep. I am running into problems when the first or last column of the table is hidden, and cannot figure out what is going on or what...

I have spent a lot of time researching this topic and am coming here as a last resort. Thank you for reading. A table is for loans and the reasons they were denied. The columns are as follows: <colgroup><col span="2"><col><col></colgroup><tbody> Loan# Narrative ReasonForDenial1...

I have a huge excel (running into 10k+ rows). The first row is title row. I want to search for "Some text here : xxx" string in two columns (AA, BA) where xxx can be YES or NO or ??? or blank. This is not nicely formatted, so we can assume some text immediately after YES or NO Strings. Also...

I have an input table where three columns are required. I would like to write a formula to check the number of rows that contain a blank in any one of those columns. I am interested to know if this can be done without a helper column and have a single formula. I thought SUMPRODUCT could be...

Hi, I came across the following problem: I haven't got that much knowledge of programming, until this moment, I only made macros, using the record function in excel. This doesn't seem to work with the macro I need atm. Little explanation: The idea is the possibiliy of manually going...

Hi, I have a table of unique emails with corresponding company and country. I want to have a column which counts the number of unique countries a company is active in. Column D is where I want the count to be in. Can someone help me with a formula for this? <tbody> Email Company Country...

Hi guys <tbody> B C D 817 25/04/2017 02/05/2017 </tbody> I have a set of Data on a sheet called "data", and the above table on a sheet called "Checks". The Dates are dynamic, and will change per users selection. I need to gather the figure from 817 on "data" sheet which also...

<tbody> ## ## ## ## ## ## ## ## ## ## XXX ## ## ## ## ## ## ## ## ## ## ## ## ## ## ## XXX ## ## ## ## ## </tbody> I would like to be able to enter the same data into the empty...