adjustment

Dim e& e=0 With Sheet1.[A2:A10] Do e=e+1 Loop Until IsError(Application. Match(e, .Cells,0)) End with I am using this code , which I got from this same forum here some time ago. It's working great, now I need some adjustment. I want to look at two columns for the...

Hi, Can someone please help me with this: I have a database with the fallowing information for 200 employees: Employee Name, ID, Department, Position title, Performance rating, Base salary, Performance rating,%increase, Previous year salary . I need to create a tab for each employee with...

I have the below formula I am trying to use to let me know if a person is supposed to be making specific adjustments. Right now every cell is showing "Check Adjustment" and the ones that are allowed to make adjustments are showing their names. I am wanting the cells to be blank if not an "RV"...

Hello - I have data in range J3:v8. And another range from Y3:AV8. I want to subtract J3 from Y3, in columnd Z3, and K3 from AA3 in column AB3; essentially skipping the column before the range y3:av8. I've tried index columns, and offset(columns) function, and I just can't figure it out...

Hi Experts, I want to get specific text from the Column A to B like follows, please help with formula <tbody> SPVAR JAN 19 SPVAR IFG JAN 19 IFG R1 Adjustment JAN 19 R1 Adjustment Stock Adjustment JAN 19 Stock Adjustment IFG FEB 19 IFG SPVAR FEB 19 SPVAR Stock Adjustment FEB 19...

so pretty much every day...there will be an adjustment to, say, cell A1 in a file I open cell A1 would have =random numbers +adjustment where the adjustment number which will change daily I then take the adjustment number and offset in cell A2 by typying =random numbers - adjustment (the...

Hi all, I have found several posts on here regarding finding the smallest number in a list and have tried to insert this information into my existing formula, but cannot make it work. I reckon for an advanced user it will be a very simple formula adjustment. My current formula is...

I am interested in using Sumifs function on blank criterion. i.e. =SUMIFS(F10:F66,D10:D66,"MANUAL ADJUSTMENT (SET)"+SUMIFS(F10:F66,D10:D66,"BLANK CELL")). Thank you in advance

{=IF(ISERROR(AA2),DM2,COUNTIFS($DO:$DO,$DO2,AA:AA,"<"&AA2)+COUNTIFS($DO2:$DO2,$DO2,AA2:AA2,AA2))} Hello, im trying to work out what i can add to this array formula, which will stop the 'equal numbers' appearing with the same duplicate rank number. For example, it currently works like this...

=IF(ISERROR(AC2),AC2,COUNTIFS($B:$B,$B2,AC:AC,"<"&AC2)+COUNTIFS($B2:$B2,$B2,AC2:AC2,AC2)) Hello, Im struggling to add something to this formula, that means if a cell is blank (blank result from an 'if' formula) in column AC, the resulting cell is also blank, and not '1' which is the current...

This is hard to explain but I have set numbers, that need to be changed based on the days of the week that are selected. This would be the given part of my sheet. Example 1 Col A B C D E F J Row 1 Sun Mon Tues Wed Thurs Fri...

Hello all, I've just recently began playing around in Excel and I'm struggling to figure this out. I've tried several variations of what I copied below, but I believe my understanding to be flawed. What I need to do is first filter the data to only include adjustments (ending in U1, U2, etc.)...

Hi, I have a sheet with a calculation in Column K for rows 2-19 of (=$J2/(1-$H$22) H22 is static adjustment %. J2-J19 is a % of total for each task Line. I want to be able to change the static adjustment % in H22 and have the values change in column K but for the totals in column K not to...

Hi trying to use this by date "07/09/17"), but not working returns 0. Probably need a miner adjustment here. Any help thanks =SUMIFS($AB1:AB1999,$A1:$A1999,"07/09/17")

I got help here on this forum a while back for a program that is at the bottom of this posting. The program is great and automatically underlined certain words in every cell in column K. The key words to be underlined were contained in a column titled "words". A situation has come up in the...

Hi all, I need a formula to accomplish the following and I can't figure this out (having a weird week). Column E has the original contract amount. If there is an adjustment, the new amount is entered into Column F. All adjustments need to net to 0. I need a formula that will tell me if the...

ok, this is the issue, i work normally with 3 or 4 different worksheets of inventory, one of the company that i work for, a shelter company, the one from customs and from the warehouse and i have to compare them, match them, know if they have different quantities or values and have all the...