fill array

  1. Z

    Numbers in different areas on page?

    Hello I have a question? In Excel I have list of the same numbers but in different areas on my sheet. Example 1 2 3 4 5. Now if I wanted all the 1's to change to 6 in place of 1 what formula would I use rather than going through the entire page changing all the 1's to 6's? Thank you for your time.
  2. C

    Array Formula #N/A Error | Manually Typing Over Data Gives Accurate Result

    Hello - I am working with a 40,000+ row excel file and using an index/match array formula to assign values. The lookup ranges are fixed ranges and I'm finding that when I fill down, I'm getting #N/A errors. My formulas work with Ctrl+D fill down on a small scale/test data, but when I apply it to...
  3. P

    Macro code for filling up data with respect to count of Next column

    Sample: A B C D E 1 ani sq 250 33 450 2 111 22 222 3 444 44 222 4 123 12 899 5 122 34 113 Now i want to make a code that fills same data in A1 and B1 up to A5 and B5, If i have data in C,D,E column upto 100 count means...
  4. B

    Filling array after autofilter and sort

    Hello, Today I have been searching for a way to load an array with data from a sorted and filtered worksheet and found quite a bit on how it does not work and various workarounds. However, see below for what is working for me. The thing is I am new to Excel VBA so maybe I am creating some...

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