block

sorry for creating another thread but in previous thread i forgot to mention this (i also tried but i failed) i have these strings: blah-blah-blahCK-N-blah blah-blah-blahLX-N-blah blah-blah-blahXF-V-blah and i have these "conditions" (2 different's) in "vlookup conditions" sheet: please...

Hello Excel experts, I have a single yet very long column with several blocks. Each block has a header/category name and each block is separated from the next block with 1-3 new lines. My data is similar to: <tbody> Fruits Apple Banana Orange Grapes Pineapple Veggies Celery...

Hello!! Could anyone please post a custom formula for data validation that could block all user input and even block empty cell. I acknowledge that the user could still copy paste but that is ok with me. Ty.

Hi, Please can anyone help me? I'm looking to have a data validation list in 'G18' showing a list of Valve Block Types based on the Manufacturer 'G17'. The list of Valve Block Types are detailed in DVI sheet (I13:Q45) Link: https://ufile.io/w0fxy Kind Regards,

Hi good people!, Please help me with either a formula or vba, whichever you reckon will work best. I have in cell A2 a number, lets say 10101. There are multiple numbers of the same value going down in column A, so lets say we have 55 "10101" numbers, then the number changes to the next...

HeLlo all Can someone help on this formula please =IF(D3<3,"C" =IF(D3>2 BUT LESS THAN 14,"B" =IF(D3>13,"A" MY DUMB BRAIN HAS A MENTAL BLOCK

I'm having a problem with a piece of code. I have searched and tried various solutions but nothing seems to work. I also don't understand why sometimes this code works perfectly, for example when restarting excel and opening workbook again. And then after I have run few other codes (workbook...

Hello, I have a strange possible COUNTIF question. I am trying to count all cells within a sequence once a sequence starts (I know I am not explaining it well...). For example, in a column there are the following totals: A A A = 3 B B = 2 C C C C = 4 I would love to figure out a way to total...

Hi I want to highlight a specific block of cells in a spreadsheet. I know this code highlights the block of cells going from A3 until the bottom of the range and to the right of the range (with data in it). However, how should I modify it if I have a sheet with data in columns A to Z, but...

Hi All, I am using Excel 2010 and I have been asked if it is possible to insert a block arrow on each row to indicate if the row has been moved up, down or has remained static. Currently the Spreasheet contains 64 rows of data and I know it may be possible to do this manually, however, before...

Hi I have 2 sheets in my workbook. Sheet 1 has list of IDs and incomplete cells in address field. In my sheet 2 I have Another list of addresses that are fully written and I want to mark the ID if I think that it is matches. The address in sheet 2 can repaeat and evertime the same id is to be...

Hi all, I'm trying to use a formula to count the number of unique "blocks" of values. Below is an example. <tbody> Row # Column 1 Column 2 1 1 A 2 2 B 3 2 B 4 2 B 5 2 C 6 2 C 7 3 A 8 3 A 9 3 A 10 3 B </tbody> In this example there are 3 blocks: Block one is rows 2-4...

Hi all, I'm trying to use a formula to count the number of unique "blocks" of values. Below is an example. <tbody> Row # Column 1 Column 2 1 1 A 2 2 B 3 2 B 4 2 B 5 2 C 6 2 C 7 3 A 8 3 A 9 3 A 10 3 B </tbody> In this example there are 3 blocks: Block one is rows 2-4...

Hello, I have created a corporate calendar where the rows contain the days of the month and the columns contain the employee's name (14 employees total) and the cells may contain V for vacation when the employee will be out of the office. I do not want more than one employee to take vacation at...

I have the follow block of data in cells A10:G16. I need a formula to search for the value 4 in this block of cells. If 4 is found then return YES, if not then return NO. <tbody>#DAE7F5[/URL] "] A B C D E F G 10 #969696[/URL] , align: center"]S #969696[/URL] , align: center"]M #969696[/URL]...

Greetings 3 events can be triggered (events = 11, 12, 13) all in column “A” Starting at range(“a51”) (the title row) Filtering a block of 4 columns 49 rows, I want to capture to (“C48”) the value in column 3 of the 1st row displayed by the filter, for each event The Macro I recorded works well...

Hi There, SO I have created a large spreadsheet but my main concern is between three data validation columns that are all working together. Column A -- You choose from a dropdown list for a particular reason Column B -- You choose state based on the region you choose Column C -- You choose...

I have a worksheet with 2 tables separated by 2 rows. Everything worked fine, and I could insert a row in the upper table without any problems. Today Excel does not accept it anymore, even though I have not changed anything to the worksheet. If I try to insert a row I get the following message...

Goodday everyone. I am preparing data to backtest a sector rotation momentum investing strategy, which is a part of my research project. For this I use intraday data. However, the query does (of course) not arrange the output like I would want it to. I have found a macro that adds a based on a...

Hello everyone, I want to block H16 and H20 when I'm on that sheet. With a button I can insert the value, so it unlocks like that. But once you can "edit" the page again. Those 2 cells have to be locked. They also change when i'm in 3 other sheets. so the simple way is to just block them and...