1. Sean15

    formula is returning #VALUE! instead of ""

    Hello: IFERROR(INDEX($E$3:$E$39,MATCH(B50,$B$3:$B$39,0)),"")*-1 This formula above is returning #VALUE ! if value in B50, is not found in range $B$3:$B$39 When I remove *-1, formula is returning "" but I need to have *-1 in formula. Can someone adjust formula so it returns "" when *-1...
  2. E

    Removing "0's" in V Lookups.

    Hi All, I have the following code in place which work, however if the search finds an empty cell it return "0" but I want it to be blank instead, how can I adjust the following formula? =IFERROR(VLOOKUP(A4,test!$A$1:$L$108,12,FALSE),"") Thanks in advance
  3. Sean15

    Help with INDEX and MATCH using two INDEX columns

    Hi: The formula below is return required value from range N if value in E470 is greater than zero. But if value is less than zero, I want to return value from range O. How can I adjust formula to return value in range O IF(E474>0,INDEX(Sheet1!$N$15:$N$42,MATCH('CF...
  4. F

    Creating a cell that is uses a formula to provide dollars based on a % or a manual entry from a different cell

    This is a duplicate post from\ I am working on a sheet that projects the amount of money each month that should be put into an...
  5. E

    How to offset cells?

    Hello! I want a function that will copy a cell from another row and put it in the current row, but in the +3 column and so on. I need to be able to adjust that +3 offset. How can I do this please? Thanks!
  6. F

    Adjust either plot area of chart to allow th horizontal category axis to be seen

    I have a chart with the horizontal axis rotated 270 degrees. I need to have the chart adjust as I make changes via VBA. This is what is recorded, but I don't know the exact height. How can this be modified to allow the horizontal axis is be completely visible and not scrunched up? Sub...
  7. R

    Adjust copy-formula to not include format

    How do I adjust this script so it doesnt paste format and only values? Sub Spara_Statistik_Vecka() ' Det här makrot kopierar veckostatistik till historik Dim Fnd As Range With Sheets("Tjänster") Set Fnd = Sheets("Tjänster").Range("N1:XFD1").Find(.Range("C2").Value, , , xlWhole, , ...
  8. R

    VBA to insert images in a grid pattern

    A wonderful forum member (Perpa) helped me modify some code he posted to insert images in rows of 3 in a spreadsheet. He suggested I start a new thread for further modifications. The macro works very well to insert images in a fresh sheet; however, I need to designate the starting point. For...
  9. S

    INDIRECT Formula

    I have the following formula:- =INDIRECT("'"&TEXT($P$1,"d mmmm yyyy")&"'!"&"A4") How can this be amended so that the A4 part will adjust (so A5, A6, A7) etc when dragged down?
  10. C

    Cell formula - Adjust range window

    Why am I unable to manually adjust the range when I click into the cell containing the formula? Here is an image to help you understand what I am trying to say.
  11. K

    Auto hide rows until values are entered

    I have everything set up so that my upc codes pull the data and only Unique codes and their frequency are recorded. Now i need to auto hide the rows between 9 and 23 if column a is blank. The tricky part is that there is a formula in the all of the cells for pulling data. until data is entered...
  12. W

    Can't figure out what my formula needs to be.

    So I've been tackling a problem for a few hours, and I just can't figure out how to approach it. I know what I want to do, but not how to do it. I'm making an automated character sheet, and for the most part it's simple. The user selects various values from dropdowns on the first tab, and...
  13. H

    Page Preview Dotted Line Cannnot Adjust

    I am trying to drag the dotted line on page preview down a few rows, but the dotted line remains in the same row i.e it won't adjust it would be appreciated if someone could assist me
  14. S

    Recalculate percentages

    Hi, Not entirely confident this is possible, but here is my situation. I have 6 cells with percentage values in, I have hard typed these values in. What I want to do is to be able to adjust one percentage value and the other 5 percentage values automatically update but keeping the...
  15. R

    Adjust "time" column when modifying row

    Hi everyone, Is there a forumla to automatically adjust the "time" in a column when any specific row is modified? For example: <tbody> Time Subject 7:00 am 7:30 am 8:00 am 8:15 am 9:00 am </tbody> If I were to modify "7:00 am" by 15 minutes to "7:15 am", I would want all the...
  16. ironsides

    Formula adjustment

    This formula below is correct as it stands the Col AB range is .10 :999.99 I want to adjust this formula to include subtract 10:19.99 =SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99") ( the sum of Col AB : Add .10 to 9.99 subtract 10 to 19.99 add 20 to...
  17. D

    Adjust Average If Formula

    Hi, I need to adjust the following formula so it only returns the average for cells in column AG12:AG377 which have a value (i.e. ISNUMBER) {=AVERAGE(IF(('Milk-Cows-Day'!$D$12:$D$377>=EDATE($G20,0))*('Milk-Cows-Day'!$D$12:$D$377<=EOMONTH($G20,0)),'Milk-Cows-Day'!$AG$12:$AG$377,""))} Currently...
  18. C

    Need help with Averageif using a date range.

    I have a pivot table that I am using to capture daily usage of items. In column A(outside the pivot table) I have a daily average formula that pulls the average of the range. I currently have to adjust the range each day when the pivot table is updated. How can I have the range in the average...
  19. B

    Question about IF in formula

    I have the following code in Column H. Sometimes I have the letters "ID" entered in some of the cells in the F column. Of course when I do this I dont get a value in my cell in column H. Could someone help me adjust the formula so I can still get my value? =IF(E151+F151+G151,E151+F151+G151,"")...
  20. countryfan_nt

    VB adjust Conditional Formatting.

    Hello friends, hope all is well! Please help me adjust the code below here. I want the code to be applied on: “each row group”. Thank you very much! Sub FormatTop10Items() With Selection .FormatConditions.Delete .FormatConditions.AddTop10...

Some videos you may like

This Week's Hot Topics