base

<colgroup><col span="2"><col><col span="2"></colgroup><tbody> COLUMN-M COLUMN-N COLUMN-P COLUMN-R 1 1 1 6 1 2 2 6 1 3 3 5 1 4 4 3 1 5 1 6 2 1 2 2 2 3 2 4 2 5 2 6 3 1 3 2 3 3 3 6 3 2 4 4 4 5 4 1 </tbody>...

Can some math genius please help me? I wish to reckon the base prices for extended healthcare plan. There are three classes in the plans: Health, Dental and Prescriptions. Each of those three classes has three available variables: A, B and C. By clicking through the co's website, I was able to...

Hi gurus We have an item table consisting of around 100k lines, the description field is only 30 characters and have been used creatively during the years. My challenge now is to split the description field to make it more groupable. One like can look like this: MA NOVA PLUS 16 10002000...

I have parts in the following format: <tbody> ABVD-JtU5d-NR393. Where the prefix, base and suffix can be any length., but there are always two dashes. I need to add a column to show the prefix, base, and first letter only of suffix. So for the above part, i want to extract ABVD-JtU5d-N...

Hi, Does any have the 'VB knowhow' to highlight a row(s) that contain a certain value? The range is c2:c200 & if it contains any of the following keywords:- base test completed OK - light green\bold base test completed failure - Light red\bold base test on test - light...

Hello Board, I have a macro automating several functions including oneadvanced autofilter. To run the autofilter I have a criteria list of 6 variables (a table with 2 rowsand 6 columns while the top row is my data base table title). I run the macrowhen I have a specific value for each...

Hello all you MrExcel experts To try to better familiarize myself with arrays, I set up the following simple macro using Windows 10 and Office 365. You will notice that I have commented out the command of ‘Option Base 1’. With this done, and I run the macro, I get the word ‘for’ displayed...

I'm trying to reference Above/Below by looking at column range AF48:AF61 and looking for the word "Red". The second reference is "Base" in column range AH48:AH61. If Red is in a Row above Base, I want to return the value "Above", if Red is in a row equal or below Base, I want to return...

Hi All, i would like to vlookup using Base values and first 4 numbers of amount columns from the data sheet. Desired result is what is required. Kindly advise. Data Sheet <colgroup><col span="2"><col></colgroup><tbody> Amount Base GFRN -13568973.89 145045 HU641814-1 1247 145045...

Hi , So I created an automated summary sheet which extracts data from multiple sheets and puts it in one workbook. I need to do conditional formatting on the data in summary sheet based on certain parameters Base Upper Lower PROD A PROD B PROD C PROD D PROD E 2 4 5 6.1 6.3...

Guys, I have the graph above and would like to create a little base between each cluster. Is that possible? If so, how? Thanks!

Hello! I need to be able to add a gradient if one fee is 10% higher to 30% higher than the base cost or 10% lower to 30% lower than the base cost. Example: I have a base cost of $15. Different comparison costs are $10 and $20. I need to be able to add a gradient color depending on the...

Hello! I am making my very first macro so I am completely new at this . I need to delete the value DEB from column BY if the value of the cell in column AJ contains 14 somewhere in the alphanumeric value. That is all I need to do. But my data base is huge (A to GW) and the number or rows...

Hello, everyone. Please for your help, I just do not know how to do it with a macro and right now I do it by hand. I have two working books. The first: is "Base" The second - I transfer information about what I want from me (usually last month). At the base I have worksheets with names (London...

Hi All, I'm fairly new to the VBA and Macro world. Wondering if one might be able to help. I have three worksheets in a workbook named : Master , Network , Data Base. The Network sheet holds all the information and feeds into the Data Base which consists of dependent down lists and a...

Hello, I have a large data base , A1:DU3459, I need a way to list the address of cells inside the data base that contain specific text. Any help will be much appreciated :nya:

Hello, I'm really struggling with this one. I believe I need to use an index match lookup combo. The goal is to pull information from sheet 1 into other "forms" (pre-populated sheets) in a workbook. I would like to return all information from column C that has the correct text in columns A...

Hello, Is it possible to create on userform a textbox which sliding the words base on a cell data when click the command button? Thanks

What's excel formula for an isosceles triangle sides? The base is 40" the height is 40"?

Good Day, How can I populate the datas into the listbox base on selected two comboxes. ComboBox1 datas located on column A "showing as months" ComboBox2 datas located on column B "showing as department names" Many Thanks