check

I am using MS Excel 2016 and the spell check will not allow me to select 'Add to Dictionary', 'Ignore Once', 'Ignore All', etc. The buttons are live, yet no response when I click them. The only button that seems to function is the cancel button. Any help on this is appreciated. Thank you.

Hello So I have 3 fields E26, E27, E28 What formula can I use to do the following: Check to see if there is a value in any of the cells and if there is a value in one cell populate E25 with a "YES" Thanks in advance

Hi All, I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format. Here is the my requirement. Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make...

Hi, I need a function not macro. to change Column I , ERROR! to red. e.g ERROR! Pls check the file ERROR! Pls check the folder I know can use conditional formulas but conditional dont found at older excel format. SO i like to use vba

I'm getting this error with the line If Sht.UsedRange.Find(What:="_START", After:=Sht.Range("A1"), LookIn:=xlValue, LookAt:=xlPart) Is Nothing Then My understanding is that the error means that something I'm referring to can't be found like a sheet or a variable or something? What I'm trying to...

I need a formula that will sum up all the checks written for the month of December and that the transaction is only a check, so that data has the date of check, amount and the fact that it is a check or a wire. Can someone help?

Hi, I have a databook with a large number of tabs that we use check figures to ensure consistency from tab to tab. These check figures are just a simple sum function that also subtracts from another tab's subtotal and when everything is working right, should sum to zero. For example, a check...

I have the following statment within my formula and it work as it is, it bascally returns "Yes" if K2 = "Liverpool". =IF(K2="Liverpool","Yes","No") However I have a list of 12 names in tab "Lookup" A1-A12 and I want to expand the formula above to also check L2 and if it matches any of the...

Hi all, I'm looking to replace a legacy system to select adverts from a database which uses some pretty beefy VBA code with a new system that uses criteria to take the information from the same database. My question is whether autofilters are a good idea or if there's an inherent fault with...

I have two columns with dates. Is it possible to check (with a single formula) that for each row, the date entered in column 2 is always greater than the date entered in column 1? many thanks

Hi All, This may be easy for some but I have looked around and can't see an answer to my issue. I have created a form with a number of checkboxes and when I pull the data from access into excel in a table format all the details from the check boxes show ether False or True. Is there anyway...

Hi I looked at other threads that cover this but can't seem to get any of their suggestions to work. I have a cell K14 that has a list of 3 options: Pre_Finished _2_Pac Veneer I have a check box that i want to hide when "Pre_Finished" is selected but available for checking when "_2_Pac" or...

Hey guys ive search this forum and found how to lock and also how to link; a checkbox to a cell but when I sort my data the checkbox remains where it was placed. My spread sheet is an inspection list where cell A1 is true/false Cell B1 is my checkbox (Active X) Cell C1 is an address...

Hi, Please can someone help me? I have this code that works fine for me when the Daily Check Sheet is active. I now need it altering so the code still looks for the same blanks cells on the Daily Check Sheet but when the sheet isn't active. Here is my code: Sub DaysandMonthsandInitials()...

I have a worksheet that has a formula to check for attendance. So I copy attendance from one note and paste into cell A. I then have a formula that says =IF(ISERROR(VLOOKUP(P2,$F$2:$F$41,1,FALSE)),"",(VLOOKUP(P2,$F$2:$F$41,1,FALSE))) If that person was in the attendance there name will show...

Hey all, Is there a way to make a macro recognize that a check mark has been checked? and if so what is it? I am trying to have a few check boxes select different ranges and a button copy those ranges and then paste them elsewhere. Thank you in advance.

Hi all: I have data in sheets(data), I want macro to do that: 1. Minus value Column(D,E,F,G,H,I) with column(M,N,0,P,Q,R) like this: Si = Di - Mi Ti = Ei - Ni Ui = Fi - Oi Vi = Gi - Pi Wi = Hi - Qi Xi = Ii - Ri 2. Check value row i = 1 to last row that: if Si<>0 or Ti<>0 or Ui<>0 or Vi<>0 or...

Ok, I have a macro that pastes data into a new or existing row in a different workbook. The data goes into columns A:J and a formula works out the data in column K. I need to be able to get the data from that specific cell in Column K into a msgbox but I'm struggling to get to work. It's the...

Hey guys i need some help with Luhn check digit formula, i need to make formula for 13 and 14 digits for card number validation, i tried and i search online but it won't help... If someone knows or have the formula please help, it would be much appreciated!!