checking

  1. P

    More than, less than, equal to, cell checking formula question

    I’m trying to query a value in a row/column and depending on the value provide an answer in another row/column. The data I’m checking against is a number sequence which needs to be queried to see if it’s between a series of more than/less than/equal to statements. Ive done these before for...
  2. BlakeSkate

    [vba] Checking if sheet exists inside array

    Hello, I have this sub from jmacleary found on this post but i thought i would be best to start a new post as the problem has shifted So the sub will grab sheets from an array and put the first column of each sheet into one sheet titled "Unknown" My problem is that the sheets are now generated...
  3. M

    Box Integration with Excel Through API

    Does anybody have any experience with using Box (www.box.com)? Specifically I am trying to use Box API calls for checking availability of Excel files, then opening them and checking them out, modifying them and saving back to Box and checking in. Their forum has limited information on the API...
  4. H

    Formula challenge, need clever help!

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>MrExcel gurus, I'm trying to improve a workbook that helps manage spending well enough that it justifies...
  5. J

    Mark if value on this date is higher than this

    Hey all, Still learning how to use excel, however I have a budget sheet I made I've been using for the past few years. Simple stuff, just my income vs outcome vs savings. This year I've added a "Wish List" Sheet to it, and I was wondering if anyone could help me with a formula. So I have...
  6. M

    if, and, or material list error checking

    Hi All Hoping someone can offer some advice, both my colleague and myself are far from experts with VBA. We have an excel workbook that collates multiple material lists using VBA and consolidates a final version for stores this is all working fine. We are now trying to add some error checking...
  7. R

    Checking for characters in cell giving weird results

    I have users who are using my file to generate a name in an approved format. This includes checking for the following characters that are NOT to be included in the name: | / \ : - [ ] { } * ? ' " ^ # I thought this was going to be a simple SEARCH function, but I'm getting results I wasn't...
  8. B

    Modify Excel 2010 macros for Excel 2000

    Good morning, I now need to save the project I created in Excel 2010 as Excel 97-2003 so that my boss can try it out. Can anyone point me to a method or tool for checking compatibility of my current macros with Excel 2000? thanks much, Bill
  9. S

    Formula not copying down in spreadsheet

    Hi All, I have a spreadsheet with a formula I tried dragging down, and even though it copies the formula correctly, the results remain the same in the entire column. I tried F9 / checking formula settings were set to automatic but that did not sort the problem either. Anyone able to help? Thanks!
  10. B

    Checking for Date Format

    Hey i have a column full of dates that i need to arrange in the format dd-mm-yyyy. I do this by this code: Sub ChangeFormat() With ActiveSheet.UsedRange.Columns("D").Cells .TextToColumns Destination:=.Cells(1), DataType:=xlFixedWidth, FieldInfo:=Array(0, xlYMDFormat) .NumberFormat =...
  11. F

    Multplie criteria to filter single colum

    Lets say whole ABCD is written in A column Row wise. I want to apply filter to show rows with only, A, C, U, K How would i go about this without manually checking these using simple filter option. Also suggest wildcard usage if for example I search for *A*
  12. L

    checking array values for matches

    Hi, I have an array for example arr(1) - mackeral arr(2) - Tuna arr(3) - Salmon arr(4) - Salmon arr(5) - Cod arr(6) - mackeral arr(7) - Tuna arr(8) - Cod arr(9) - Salmon arr(10) - Cod I need to check the arr values for any matches. So for example check arr(1) against arr(2) to arr(10) and so...
  13. N

    Excel Macro VBA - Subtotal function issue

    Hi everyone, I have made a macro to add in a table a sub total from a filtered database. The sub total function being the only solution, because the SUM function is taking into account all the rows, and I only want the ones which are filtered. To do so, I have write this ...
  14. P

    How to specify 'cut off point' for pulling data from within a cell

    Hello, I have the below code that inserts data from a text file into cell A1, if the text file contains the string "Checking for drops": Dim FileNum As Long, TotalFile As String FileNum = FreeFile Open "C\pete.txt" For Binary As #FileNum TotalFile = Space(LOF(FileNum)) Get #FileNum...
  15. S

    IF AND formula

    Hi I am using Excel 2013 and I want to use an IF AND statement to check the value of 1 cell and another. So I am checking: if B1=1 AND B2=100 is true I want to return the value "2" if B1=1 AND B2<100 I want to return the value "1" if B1=2 AND B2=100 is true I want to return the value "3" if...
  16. H

    VBA - code for a single worksheet

    Hello All, I am writing a code that does the 2 steps listed below, a total of 50 times. Below is a description of what the code does. Step 1) The code looks for a single cell to see if it is blank, or to be precise, if it is A1="". If the cell is empty (" "), then the code skips step 2 below...
  17. B

    if three values true then OK else missing value

    I have scenerio in excel Job Nature, in Column T which have values (W), (F) (M) Days to check in Column S which have values "No. of Days" & Paid W/Card in Column N which have values True , False The Thing I want to check is, if Job Nature is (W) and No. of Days is <= 365 and the W/Card is Ture...
  18. M

    Checking a range of cells for a text match

    Hi, I am looking for help checking for a text match, so I can show a tick or a cross in the cell next to it. I have 2 sheets. Interface and Data. In Data it has, First Name, D.O.B, Postcode ect. In the interface the user types First Name into cell C10 and then it check the range of Data!B:B...

Some videos you may like

This Week's Hot Topics

Top