beneath

Hi, I have an excel spread sheet with a drop down function in Sheet1 cell A2. In Sheet 2 along Row 1 I have titles of systems running across the page. Under each title there are a number of names beneath each. The drop down in cell A2 in Sheet1 corresponds to the titles in Sheet 2...

Hello, I am looking for some inputs on how i could extract a value from an adjacent column or row beneath based on a unique value in previous column. I have attached a picture for reference. Basically if column B has "AS3DW", it should like for value starting with 678 in column C and also check...

in Column A I have several categories. Chefs Features Entree2-Mindful Accompaniments STG/LTO (just to name a few) Are a few of these categories. After EACH category, there are 4 items (all in Column A) Is there a formula to extract all the data in the cells beneath each category? For this...

I need to sum everything in a column that is beneath a zero (the last 0 restarts the count). The formula I need should look at this and produce a value of 10. thanks. 1 2 5 0 5 4 1

Hello, I can use this code to retrict the scroll area of a worksheet to the used range: Sheets(1).ScrollArea = Range(Sheets(1).UsedRange, Sheets(1).UsedRange(2, 2)).Address Say, for example the scroll area has been restricted to $A$1:$M$69. You can scroll down until row 69 is at the top of...