row and column variables

  1. P

    Noob needing help on conditionally hiding rows based on condition of cells

    I have a complex spreadsheet which has a summary report. There are perhaps 200 populated rows on the summary, but for clarity I wish to set row height to hidden or 1 based on what is in the row. For example, in row 45 if cell B = " " I would like that row hidden or compressed. Row 46 may appear...
    • pwnorcal
    • Thread
    • conditional format in vba row row and column variables row height rows
    • Replies: 6
    • Forum: Excel Questions
  2. S

    Automatically restart formula given that parameter is met?

    Hi Experts, I am in need of some assistance. I have a list of multiple id's in column A, column b contains data of the number of items linked to the ID. I want to generate a list of every page pertaining to each ID as follows, so i want in column C (for example) "a - Page 0001" all the way...
  3. E

    Average of a dynamic range (starting from the4 bottom!)

    Dear All, I am new in VBA and I would like to do the following for my master w/s: I have a trend of time vs. variable XD (the length of this trend will vary - can be a total time of 15 hours, 20 hrs, 5hours etc. with variable intervals as well). I would like to calculate the average of the...
    • Ealglez
    • Thread
    • average 0 formula range row and column variables vba & excel 2013
    • Replies: 1
    • Forum: Excel Questions
  4. R

    Sum data based on Row and Column variables (Excel 2007)

    Hello all, Glad to be back on posting. I'm working on a workbook that will combine a cash flow report by category and also by date. The categories can change (which I think is the easiest part) but so also can the frequency of data. For instance, you choose how you want to see the data...
    • RBenny
    • Thread
    • array multiple variables row and column variables
    • Replies: 4
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top