identifying

Does anyone have a good method of identifying cells that need to be modified in a spreadsheet to make it easy for the user to locate? I have not been able to find a way to highlight a cell or change the text color but not have them print in that manner, since I have color images on the form I...

I currently have a trend line with the following trend line equation, y=-0.0131x+580.53. I am trying to determine the start and end points of the trend line. I have 19 data points please let me know if sharing the data points would be helpful or are they relevant considering I am addressing the...

:rofl::rofl: I am simplifying a bank reconciliation by identifying each transaction on the bank and GL into categories. I tried nesting: =IF(T33="*DES:ACH*","PatientPayment",IF(T33="*CIGNA*","PatientPayment",IF(T33="*DXC*","Dental",IF(T33="*DENTIST*","Dental",IF(T33="*DES:DEPOSIT*","Other...

I have converted bank statements from PDF to Excel and now need help identifying the vendors in the line detail of the transactions. I can clean up some statements using Text to column but need help separating the vendors from the other text. Any help would be greatly appreciated. Once I have...

Not sure if this is even the right question in my title so that's why I am asking this and not just searching online for the answer. Below is a link to my screen shot. It shows two sets of data. Row 65 - 73 shows my list unsorted and 75 - 83 shows my list sorted. There are three repeating codes...

Hi there and happy newyears! What I have here is essentially a word document that we'v taken and copy-pasted all the information into excel. We currently use a macro that is identifying all the information and then seperating everything into each column. The one thing that the macro is not...

Hi. I have a macro that looks for 2 numbers and compare if they are the same. It's failing and I'm not sure why. In order to test it I've added the following 2 message boxes: MsgBox salesorder1 & "=" & salesorder2 MsgBox salesorder1 = salesorder2 And this is the result: Why is it not...

Hi All, I need some help with an IF formula in identifying if DateTime A is after 12:00pm the day prior to DateTime B then 1,0. For example, if DateTime A is 8/17 12:01 and DateTime B is 8/18 23:00, the formula will flag DateTime A as 1 and if not true then 0. My data source is dynamic and is...

Hi, I'm looking for a way of identifying all entries for a Patient ID where the Patient ID's have conflicting "Country of Birth" entries recorded. Entries for each Patient ID may all say either ZZZ or GBR, but they cannot say both. The problem with identifying them being that: Rows may...