Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Home
- Microsoft 365
- Excel
- Excel Office Scripts - This formula will not run automatically does fine manually.
Excel Office Scripts - This formula will not run automatically does fine manually.
Discussion Options
- Subscribe to RSS Feed
- Mark Discussion as New
- Mark Discussion as Read
- Pin this Discussion for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06 2023 09:38 AM
Good afternoon,
I am working on automating a massive data sheet (regenerates every month) and I have gotten everything to work so far except this one step.
After all the automation so far its a single sheet. What I am trying to do is organize each WO by Unit name using this function:
"=IFERROR(INDEX($E$2:$E$10000, SMALL(IF($I$2=$D$2:$D$10000, ROW($E$2:$E$10000)-1,""), ROW()-1)),"")"
Which works just fine when typed in and dragged. However when I automate it using the code editor recorder, it always claims to get everything, and then when run on a new workbook (exactly the same copy) it fails. Displaying this error:
Line 4: Range setFormulaLocal: The argument is invalid or missing or has an incorrect format.
Before Automation:
| UNITLONG | UNITNAME | WO | HOURS | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 1.167 | HDA20Y | HDA20Y | HDA20Y | ||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 1.967 | 0 | ||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 1.783 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 2.626 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 0.422 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 1.367 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 2.554 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 2.759 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 3.237- | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 3.237 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 3.658 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 3.227- | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 3.227 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 0.36 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 1.286 | |||||||||
| LDR125IS6CA3213DA + | LDR125 | 1E+09 | 0.644 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.421 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 2.605 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 0.251 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 0.163 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.003 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.334 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 0.743 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.848 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 0.83 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 2.939 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 0.527 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.012 | |||||||||
| HDA40YT6NJ21O9CB | HDA40Y | 1E+09 | 1.085 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.666 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.573 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.473 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.826 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.704 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.09 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.151 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.972 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.732 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.654 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.944 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.51 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.113 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.414 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 2.417 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 3.524 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.614 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 1.475 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 1.049 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 0.806 | |||||||||
| HDS60FT6UJ3111CA + | HDS60F | 1E+09 | 1.361 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 3.25 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 1 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 0.75 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 1.15 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.285 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.5 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.615 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.5 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.968 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.766 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.003 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.98 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 2.007 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.845 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.497 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.149 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.1 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.872 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.9 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.355 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.754 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.637 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.715 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 3.098 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.746 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.772 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.488 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.685 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.456 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.743 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.167 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.191 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.573 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.941 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.937 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.904 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.984 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.108 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.624 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.243 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.256 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.917 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.646 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.776 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.647 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.307 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.115 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.271 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.565 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.988 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.821 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.014 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.061 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.831 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.641 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 4.417 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 2.02 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1.045 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 3.151 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 1 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.308 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.793 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.395 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.912 | |||||||||
| HDA20YM6NB11O9CB | HDA20Y | 1E+09 | 0.587 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.734 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.418 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.597 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.715 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.593 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.476 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.119 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.137 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 2.701 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.822 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.696 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.583 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.5 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.594 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.605 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 2.192 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.946 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.233 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.713 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.701 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.639 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.567 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 3.25 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.866 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.492 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 0.577 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 1.25 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 2.25 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 4.674 | |||||||||
| HDR45IS6CA3214DA + | HDR45I | 1E+09 | 4.614 | |||||||||
| HDI160FT6UJ3C26CA + | HDI160 | 1E+09 | 1.417 | |||||||||
| HDI160FT6UJ3C26CA + | HDI160 | 1E+09 | 0.986 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.16 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.113 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.358 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.403 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.965 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.381 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.847 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.2 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.437 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.648 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.853 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.04 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.863 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.252 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.775 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.357 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.059 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.05 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.329 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.787 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.613 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 4.221 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.744 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.545 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.208 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.573 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.25 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.25 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.98 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.041 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.745 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.433 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.027 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.781 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.161 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.529 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.593 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.369 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.029 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.772 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.22 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.438 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.75 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.336 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.022 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.316 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.69 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.511 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.728 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.296 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.333 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.782 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 4.75 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 3.5 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.51 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.288 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 2.694 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 1.333 | |||||||||
| HDR190JS6CA3213DA + | HDR190 | 1E+09 | 0.5 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 0.251 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 4.5 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 0.071 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 1.334 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 1.707 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 3.507 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 5.234 | |||||||||
| HDI130FT6UD3326CA + | HDI130 | 1E+09 | 5.165 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 1.167 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 1.181 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 7.75 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 4.313- | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 2.029 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 4.313 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 0.683 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 1.5 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 5.5 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 3.333 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 0.503 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 2.298- | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 2.298 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 0.512 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 2.272 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 3.25 | |||||||||
| HNI100PT6UD3126EA + | HNI100 | 1E+09 | 0.623 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 0.333 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 2.667 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 0.667 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 0.333 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 2.333 | |||||||||
| LNI100PT6UF31O6EA + | LNI100 | 1E+09 | 0.85 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.167 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 5.400- | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 0.776 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 5.4 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.469 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.635 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.436 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.95 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.353 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 0.666 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 2.603 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 0.298 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 2 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 46.237- | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 46.237 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.75 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 1.75 | |||||||||
| LNI100PT6UD3126EA + | LNI100 | 1E+09 | 0.733 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 4.75 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 1.333 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 2.567 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 3.19 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 2.286 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 2.48 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 0.643- | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 0.643 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 0.174 | |||||||||
| HDI130FT6UJ3C26CA + | HDI130 | 1E+09 | 0.65 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.326 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.124 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.547 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.029 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.4 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.962 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.661 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.058 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.224 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.818 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.498 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.94 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.96 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.488 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.221 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.044 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.291 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.511 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.525 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.379 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.686 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.53 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.444 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.511 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.017 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.5 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.5 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.08 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.335 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.622 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.197 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.595 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.407 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.564 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.738 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.25 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.845 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.105 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.294 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.784 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.803 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 1.504 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.693 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.038 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 2.25 | |||||||||
| WDI130FT6UD3316CA + | WDI130 | 1E+09 | 0.833 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 0.648 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 0.765 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 0.881 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 1.41 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 2.448 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 2.571 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 1.006 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 1.214 | |||||||||
| WDI130FT6UD3416CA + | WDI130 | 1E+09 | 2.419 |
Labels:
- Labels:
-
Macros and VBA
1 Reply
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06 2023 12:31 PM
Here recorder generates the script with relative references in RC notation, like
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Set range M2 on selectedSheet
selectedSheet.getRange("M2").setFormulaLocal("=IFERROR(INDEX(R2C5:R10000C5, SMALL(IF(R2C9=R2C4:R10000C4, ROW(R2C5:R10000C5)-1,\"\"), ROW()-1)),\"\")");
// Auto fill range
selectedSheet.getRange("M2").autoFill("M2:M14", ExcelScript.AutoFillType.fillDefault);
}Thus wrong range reference appears. Correct in the code formula manually, like
function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Set range M2 on selectedSheet
selectedSheet.getRange("M2").setFormulaLocal("=IFERROR(INDEX($E$2:$E10000, SMALL(IF($I2=$D$2:$D10000, ROW($E$2:$E10000)-1,\"\"), ROW()-1)),\"\")");
// Auto fill range
selectedSheet.getRange("M2").autoFill("M2:M14", ExcelScript.AutoFillType.fillDefault);
}it shall work. At least in that part.