• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Formula can't read this "-1.86517468137026E-14"(Scientific) as "0" (Numeric)

    Hello everyone, My pivot table returns zeros in -1.86517468137026E-14, 1.46549439250521E-13, -2.28261853862932E-13 format and I need my formulas to read this as zeros. I changed the output numbers to accounting, numeric but it didn't work. Example; Pivot output A1: -1.86517468137026E-14 A2...
  2. A

    Listing files names and hyperlinks in a spreadsheet.

    Hi all, I need a macro to look into a folder (i.e. C:\Documents) and list all the files (*.pdf) in a spreadsheet and hyperlink them. Thank you very much!
  3. A

    Find and delete the last row in a table.

    Hi everyone, I am looking for a macro that will find and delete the last (blank) row in a table (It can look for a value in any table cell). It gets tricky because I have two tables in one sheet and I need two individual macros for each table. I don't want macro to find any blank row...
  4. A

    Data Validation (Dependent Drop Down List)

    I want to say that this is a great website! I've learned a lot from this site but I have been trying to create depended data validation and couldn't find an answer to my problem. I can create drop down list for people to choose a time to sign-in, however, I can not get sign-out data...
Back
Top