review

  1. S

    Formula question.. hopefully not to difficult

    I have a table with 47k records on it. Column J has a number of values. I am concerned with the tracking user "jjj222" Column D has Principal. Column E has repayment amount. What I am trying to accomplish: If borrower (column K) has a balance (D-E) with user jjj222 (found in column J), show...
  2. T

    Return value based on latest date for entry

    Hi I have a spreadsheet with factory name, review date and overall evaluation. Some factories may have multiple entries and reviews. I would like the overall evaluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the...
  3. S

    review for duplicates and fill the same

    Hello smart people, I have a large spreadsheet i'm using for people's names/addresses/phone numbers etc I have to add more constantly when a new download becomes available. However, on my initial sheet I fill the row (example, they don't want to be contacted is red, left a message yellow) I...
  4. I

    Multiple conditional formatting

    Hi all, this one has been getting on my nerves for a while now! Hopefully someone can help. I have some basic formula to work out the date 6 months after and nine months after column I. I also have some conditional formatting to turn columns J & L red if the date exceeds TODAY() which also...
  5. S

    vba, excel Shapes.AddLabel, Shapes.AddTextbox - locked/uneditable

    Hello - I am frustrated. I spent a few hours today on this and thought I would find 1 resource to solve this but I found pieces of it. SO maybe I'm not searching the right term. I"m trying to understand the difference between a textbox vs a label, a 'userform'. I don't know what I actually need...
  6. J

    TEXTJOIN with Multiple Conditions

    Hi all, Using Excel for Office 365 MSI 16.0.11 x64 version 1902. I have a scenario where I think TEXTJOIN would work, but I can't figure out how to concatenate several IF statements together. I have: - Column A (id) with hundreds of row entries, simple numbers 1-..... - Column B (category)...
  7. S

    Userform Listbox Refresh

    HI Not a programmer but hopefully doing a good job of finding and playing around with code to get what I want. I've created a spreadsheet that has raw data on a worksheet. I have one macro that scans through the data and the last column (J:J) is changed to REVIEW DUE, FOLLOW-UP or COMPLETE if...
  8. N

    generate weekly report

    can someone help to generate weekly summary per this file? raw data entries: <colgroup><col><col span="4"><col></colgroup><tbody> Date Status1 Status2 Status3 Status4 Week 02 April 2019 Approved Approved Approved Approved 14 03 April 2019 Reject 14 08 April 2019 Approved Reject...
  9. S

    Return the current quarter between two dates

    Hello Excel Gurus! I'm trying to find a simple formula to give me the currentquarter between two dates. I have to do quarterly performance evaluations on mypersonnel; however, the traditional fiscal year quarters work for works for thepersonnel I have that have been here since 10/1/2018. For the...
  10. H

    "comments" section missing off "review" tab

    hello, i have just changed my licensing for 365, and reinstalled all office 365 business apps. i have just opened a excel sheet i had and tried to edit the comments. the problem is that there is now no "comments" section showing under the "review" tab, and no comment option appearing when i...
  11. H

    Help me develop this formula?

    Hi all I have the following formula which is working great (as far as it goes): =IF(AF6>AA6,"Not due yet",IF(AF6>AA6+7,"~ 7 days late","+ 7 days late")) AF6 is Last Review Date AA6 is todays date. So the formula is looking to show: If the Last Review date is overdue return one of the messages...
  12. C

    Cross-referencing a large set of categories pair by pair

    Hey guys, let's say you had to compare a very large group of categories, each with a set of defined traits. The goal is to compare every category against every other category and identify the pairs that are MOST SIMILAR in terms of their trait set. That is, all those category pairs that are...
  13. A

    Having Issues With Conditional Partial Vertical Column Sums Based On Date Ranges

    :eek: https://imgur.com/a/G6LurIo Hello Folks. Hoping someone can assist with this dilemma. The image linked herein shows what the spreadsheet looks like. How would I write formulas in cells I11, J11, K11, and L11 such that they all reference the entered start and end dates in cells J5 and...
  14. M

    REOPEN - Thread: VBA to copy and move data based on multiple criteria to new sheet 1077820

    Hi - Sorry if breaking protocol here, but I posted to an old post this morning which probably doesn't have any visibility at this point. I placed the URL below and would appreciate if someone could review and reply to the inquiry. Thanks in advance...
  15. E

    Adjusting a Formula.

    Hi All, Can I add an Or statement to the below for a second criteria that if Z2 = Yes and R2<=j2 return "Review" otherwise return "--". =IF(AND(P2>0,Z2="Yes"),"Review","--") If possible can someone return the exact code I should use? Thanks in advance
  16. S

    VBA Copy/Save as -> missing formatting

    I have code to export / copy sheets to a new workbook. The issue is, some of the color formatting is missing. Can someone help answer why? Sub Report6Export() Dim Fname As String, ws As Worksheet Dim Ary As Variant, tmp As Variant Dim i As Long Fname = "Review - " &...
  17. Y

    Urgent required help

    =IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(K19),IF(OR(D19="ECA to Native Processing and Review DB Upload",G19="02 Pending PM Review",G19="03 Approved by PM"),ISBLANK(L19),IF(OR(D19="ECA to Native Processing and Review DB...
  18. Y

    errror

    =IF(OR(F2="Archive DATA - ECA",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Archive Data - Review",I2="02 Pending PM Review",I2="03 Approved by PM"),ISBLANK(S2),"False",IF(OR(F2="Client Training",I2="02 Pending PM Review",I2="03 Approved by...
  19. A

    blocking cells

    I have tried to block just a few cells with formulas in a sheet leaving free the rest of the cells to be filled by variables if needed, I followed the Microsoft title "Lock or unlock specific areas of a protected worksheet" with NO success I wonder what I did wrong this is what I did: I...
  20. G

    Counting unique instances given another criteria

    Hello! I am creating an Access report. Inside the report, I have created a box that will count the number of project inspections (based on Review type column) given a date. It is worthy to note that a single project inspection on a given day can have multiple findings. I am not interested in...

Some videos you may like

This Week's Hot Topics

Top