ccc

Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...

Hi, I have a set of data like this <tbody> AAA 2-May-20 BBB 18-Jun-20 CCC 29-Mar-20 DDD 9-Feb-21 EEE 9-Feb-22 FFF 9-Feb-20 GGG 9-Feb-23 HHH 9-Feb-20 JJJ 27-Feb-28 KKK 2-Jan-27 MMM 14-Oct-21 NNN 15-Oct-19 </tbody> I want to sort it like this <tbody> Before 2020 Between...

Dear All I am using Excel 2016 and want to split a string mix of characters (C) and numbers (N) in three columns Before (1 Column) CC NNxNNNg CC CCC NNxNNNg CCCC CC CC CCCCC NNxNNNg CC CCC NNxNNNg CC CCCCCCC CCCC CC NNxNNNg CC CC NNxNNNg CCCCCCCC CCCC CCCCC NNxNNNg CCCCC CCCC CCCCC CCCCCCC...

I am trying to get my table to look like table 2. Any help would be appreciated. <tbody> Name Address Insured Address Policy Policy2 John Doe 123 ABC ST 123 ABC ST 8888A John Doe 123 ABC ST 123 ABC ST 9999B MIKE A 345 CCC ST 345 CCC ST 5555C MIKE A 345 CCC ST 345 CCC ST...

Hi thanks for your time in advance. I know in excel i can split worksheet into multiple worksheets based on column value. However my report size is quite big and i only need one criteria, can i split into sheets based on values? For example, i would need a macro to split the below data just...

<tbody> I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to be dictated by the product name in F2. So the formula needs to be clever enough to change the volume if the name in F2 changes...

Hello I am searching an alternative to the pivot table. Since the pivot table works only if data are in the same header (column) how can I select a certain type of date for a given reference? Let me explain here. I have a similar situation as below: <tbody> ID Date Value 1 Value2 ID Date...

Hi guys, I have a question regarding the best way to find the row number of a cell containing an exact string which in my example is a single letter. The problem I'm encountering is that this letter also happens to be within words of other cells. How would I go about returning only the row with...

Hello all, I want to Create a sub of autofilter in VBA that will autofilter my range by a criteria that is written somewhere in my sheet, for example: I have a table: code|Pname|price| 1 aaa 10 2 bbb 11 3 ccc 12 4 ... ... ... and in cell A1,A2,A3 a list of...

I am working on 'Word Document' where a text is selected and converted into variable let say CCC. I want to transfer this CCC to 'Excel Workbook' Sheet1 in next empty row. I am trying following code but it seem not doing anything: Set CCC= Selection.Range.PARAGRAPHS(1).Range Set...

Hi Excel gurus I have a long list of company names (list a) and a shorter list of company names (list b), i'd like to search for each of the companies in list b within list a BUT need to use fuzzy search, i.e. If list b contains "AAA BBB CCC" - need to know if list a contains either "AAA"...

I have the following problem. I have a Column "Data" and a column "Criteria" and I want to replace the cells of "Data" with "#N/A" based on: if cell of "Data" is a equal to one of the criteria, then replace if cell of "Data" is a subset of the criteria, then replace if cell of "Data" is not a...

Hi I need an index match to get all the b1:e1 which are greater than 0 Anyone can help ? <tbody> a b c d e f g h i k 1 aaa bbb ccc ddd 2 0 1 0 1 bbb ddd 3 1 2 3 0 aaa bbb ccc 4 2 0 0 0 aaa 5 6 </tbody>

Hello everybody. I've a situation like this: I've to find the string in cell A2 ("C57") in column F (the recurrences could be 0 or 1), and then copy the values INFO 1, INFO 2 and INFO 3. In this case: B2 EEE C2 CCC D2 AAA https://imgur.com/a/IW3vL I've tried with INSTRING and VLOOKUP, but...

I can accomplish this task fairly easily with a pivot table or a macro but wanted to see if a formula could be used so it is dynamic. Given a table starting in A1, B1 like this <tbody> Project Level AAA 1 AAA 2 AAA 2 AAA 3 AAA 3 BBB 1 BBB 2 BBB 2 BBB 2...

Dear All, I have one user form details of which are getting capture in excel sheet – Sheet1(Data). Currently with the help of userform code I am just able to put the details like below – i.e. only till its opening stage. <tbody> A B C D E F G 1 Date Region Issue Type...

Hi I haven't been able to figure out how to phrase this to utilise the search here or on Google to find the answer, although I'm sure it is fairly simple. I have data in the following format: <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Company Rate...

Hi, I am trying to run multiple lines sql code within VB, but I dont know how to separate/concatenate the code.... part of my code is: vSql = " with AAA as(select BBB,CCC from DDD where ( EEE as 'XX%' or FFF like 'YY%') "

How Can I merge cells using vlookup? I have to merge cells from TEXT Column for each ID ID NAME TEXT 1 AAA hfjkjvk 1 AAA djhjfdhf 1 AAA dfklkdfj 2...

Hey guys, Another thing I'm trying to do over here: I have three lists of data like this: <tbody> Lis 1 List 2 List 3 1 a c 2 aa cc 3 ccc ccc </tbody> Is there anyway that I could get all the possible combinations in the table in three diferent columns? Something like this...