aaa

hello, I have a little problem. here is my sample excel data. its fairly large. <tbody> A B C D E AAA AA 1 AAA BB 2 null null 3 BBB CC 4 BBB DD 5 </tbody> So i want to change the values in column A and B. so i want to input a number (1-5) in column B and values...

Hi, I'm sorry for the title being so vague, but i quickly need to run some numbers and the source data is a bit messy. The simplest way for me to do this with my limited knowledge is an IF statement, but i think it's going to be very messy in terms of nested IFs to do what i need, so i wonder...

Help needed! Data below shown John has 3 outlets in Jan. What would be the formula for me to put in C3 to get 3? If I change the manager to Smith, will the number change automatically as well? Thanks! <colgroup><col><col><col><col><col></colgroup><tbody> A B C D 1 Month Jan 2...

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...

Casual Leave balance Calculation Period Start 01-Jun-2017 Period End 31-Jul-2018 Total Casual Leave 10 for 12 month (.83/month) but it should be calculated from date of joining. <tbody> A B C D E Employee Date of Joining Opening Leave Availed Leave Balance Leave AAA 28-July-2017...

Hello, I am having some trouble with my vba code. It seems to work in f8 but not when I run it in f5. When I run it in f5 the item is not recognized and equals nothing. I have pasted the code below. Sub SlicerSelect() 'On Error Resume Next Worksheets("Sheet3").Activate 'Dim cache As...

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...

I have 2 data sets : 1. Data order <colgroup><col><col><col></colgroup><tbody> Product Order Time Qty AAA 1:30 AM 1 AAA 2:00 AM 1 AAA 2:15 AM 1 AAA 2:15 AM 1 AAA 2:15 AM 1 AAA 2:15 AM 1 AAA 2:30 AM 1 AAA 2:30 AM 1 AAA 2:30 AM 1 AAA 2:45 AM 1 AAA 3:00 AM 1 AAA 3:00 AM 1...

DATA FILE <tbody> Grn Name Discount % Class 001 AAA 100 5 002 BBB 100 6 003 CCC 4 004 DDD 100 3 005 EEE 1 </tbody> <tbody> Concession i want to maintain below list just enter 100 in this cell </tbody> <tbody> Sr. No. GRN Name Class 01 001 AAA 5 02 002 BBB 6 03 004...

I am trying to solve problem. I have in my dataset among others also columns named customer and product. Customer can have many products and entries are repeated. I need to have a new column to give number of unique products based on every row of customer column. Dataset is huge and it's needed...

Hello experts, I have different license plates belonging to various companies, but that can be "drafted" to other companies. It is easier to explain it sample data: <tbody> License Plate Company Start Date A1 AAA 01-01-2017 A2 AAA 01-01-2017 A2 BBB 01-12-2017 </tbody> On another sheet...

I'm still really new to VBA. And this is the last portion of a long list of macros for completing data cleanup and analysis for a report. Maybe this isn't the best way to do this? I'm still new to this, so I'm open to other suggestions. But it needs to be a macro. This is basically what it...

Good evening! I have some code: Sub sqbrackSub() Dim arr() As Variant Dim x As Long x = Cells(Rows.Count, 1).End(xlUp).Row arr = Cells(1, 1).Resize(x, 2).Value For x = LBound(arr, 1) To UBound(arr, 1) arr(x, 2) = sqbrack(CStr(arr(x, 1))) Next...

Hello! I have some macro: Sub bracketsSub() Dim arr() As Variant Dim x As Long x = Cells(Rows.Count, 1).End(xlUp).Row arr = Cells(1, 1).Resize(x, 2).Value For x = LBound(arr, 1) To UBound(arr, 1) arr(x, 2) = brackets(CStr(arr(x, 1))) Next x...

Hi, I wish to filter a column based on an input range in same (or another) column for eg. <tbody> A B 1 Account Value 2 bbb 150 3 aaa 100 4 ccc 200 5 aaa 150 6 bbb 250 7 vvv 200 8 aaa 150 9 ccc 100 10 ddd 50 11 sss 250 12 bbb 100 </tbody> Criteria range for the...

Hello all , I have this macro which can only copy and transfer data one col at a time . Im wanting to copy from workbook AAA range A2:BF434326 to workbook BBB destination A2 . No idea how to alter this macro below . Sub Test() Workbooks("AAA.xlsm").Worksheets("Sheet1").Columns(1).Copy...

Hi, I am trying to populate a cell with information based on certain text in the column, and using index match to insert the data in the correct line. Below is a summary of the data. It seems simple but I just can't find anything that works. Excel 2010 <colgroup><col style="width...

Sorry, first post so forgive me if I get anything wrong. I am a fairly experienced excel user and happy to use any formula for my requirements I'm using 64 bit Excel 2016. My issue is trying to transpose large amounts of data using a formula (vlookup/hlookup/index match are in my mind but not...

Hello, I am attempting to split a string of data located in one cell into multiple single cells, with "." as the deliminator in access. I normally work with excel and would just use the text to column function, but that is not an option here. my data will not be fixed in length, here is an...

Greetings! Is there a formula to fill down in column E with text from the first cell to the left that has text? The text in columns A through D are different lengths and could contain both text and numbers. I've a spreadsheet with more than 1900 rows. Thank you in advance. <tbody> A B...