reading

Hi, does anyone know how to stop Excel (on a Mac using O365) from reading blanks as zeros?

Hi, I have spreadsheets that have multiple readings in. The data can be 500 readings across (columns) by 500 down (rows). Basically a large square of thickness readings. Sometimes it can be even larger. I want to be able to get a minimum reading quickly from say every 25x25 grid of data and...

I have a facility that operates 6-days a week Mon - Saturday. I need to be able to calculate the net workdays. In cell L2 is the month. For the normal workweek Mon-Friday I have the following formula "=NETWORKDAYS(L2,EOMONTH(L2,0))". Reading about the NETWORKDAYS.INTL I see you can designate the...

Hi, I am reading a csv file and I want to check if the data is a string or an integer. But I am having trouble doing this. hen lineitems(1) = "row text" it crashes. How to fix this? for i = 1 to 100 If EOF(1) Then MsgBox "Error" Line Input #1 , linefromfile lineitems =...

I need to crate an Excel model of a nomograph - picture three parallel vertical lines with different (non-linear values) on each. If done manually, by drawing a straight line between the values on the two outer lines and reading where it intercepts the middle line gives the reading I want. How...

Hi, I have a tsble of data and am trying to return the date from col C of the last entered reading in col F . The formula =ADDRESS(SUMPRODUCT(MAX((F3:F1919<>"")*ROW(F3:F1919))),3) gives me the cell address $C$1809 which is the correct cell at present. I've tried wrapping this into =TEXT(...

Hi all. Does anybody have a good suggestion to resolve this issue within excel? We have 1 user for the file. (dispatcher) Information includes Dock Departure Times. However, Throughout the building are monitors linked into the network where the file resides. Is there a way to update this...

Hi, so I got this raw data <colgroup><col span="2"><col></colgroup><tbody> Name Class Hobbies Andrew Apple Swimming Ricky Apple Reading Edwin Orange Tennis James Pear Reading </tbody> and I want to make drop down list with multiple condition (in this case, class and hobbies will be...

I'm using the below code to try and save a CSV file of Sheet 4 to the same file path as my existing .xslxm file. I know I'm missing something and the below may not even make sense but I'm learning VBA on the fly, mostly from recorded macros and reading other code on forums. Any help could be...

Hello all, what a wonderful place this is...loads to learn here, just need a bit more time to browse the posts. In the mean time, I have a question to pose of my own, it has so far caused me to waste a huge amount of time, and effort...and I have got nowhere. I hope you may be able to help...

Hello, I need help with a formula or macro(?) to provide the difference between to meter readings. The catch is I would like a running total reading ,similar to the odometer in your car, but the meter only has 7 digits, when the meter gets to 99999999, it rolls over to zeros but i need excel to...

Hi guys, Looking for some help with a formula i'm using, i've got a Two-Way Lookup: Column = Name, Row = Date =(VLOOKUP(E2,Service!A1:NB35,MATCH(B2,Service!A1:NB1,0),FALSE)) It works great for reading data from the table, however i want to reverse this process. I want it to add data instead...

Could you help me how to write VBA to open file which have password for writing. So I would like to open this file only for reading. Thank you.

Hi I am reading the article below and the author is using Combo chat. I am using excel 2010 and I do not see combo chart? any idea why please? Thank you. http://www.guru99.com/creating-advanced-charts-in-excel.html

Hi All I've tried to find a solution to this but i just can't see it. using a really basic nested IF =IF(D4=1,600000,IF(D4=2,525000,IF(D4=3,375000,IF(D4=4,225000,IF(D4=5,100000,IF(D4=6,25000,0)))))) I am only getting a return of 25000 or 0. I have this replicated in D4 to D7 with the scores...

Thanks for clicking! So a little bit of background first. I'm at the end of my first Excel class and I've been having fun creating little things for the house like budgets and such. I'm getting bored now and am looking for some challenges. Eventually I would like to a get into VBA so I can...

I have run into some weird behavior in the immediate window when querying values of some stopped code. mycell is dimmed as a range, and row is a long integer. ? mycell(row) 'results in pop up window, overflow, run time error 6 ? mycell.Offset(row) 3/10/1903 9:10:57 AM ? row 5148 ...

I'm getting my feet wet with objects and started reading Head First Design Patterns after reading http://www.cpearson.com/excel/Implements.aspx The sorting example showing the value of interfaces from cpearson.com worked, but trying to follow along in the first chapter of the design patterns...

I've written a basic spreadsheet to calculate new electric bills when readings are estimated and then a lower reading is given by a customer , for example 65765 is an actual reading then 69000, 70000, and 71000 are estimated, then the customer gives a reading of 67898. If this happens we have to...

Hello, I tried to search for this but had no luck. Could be just an issue with knowing what to search for. If so I apologise, can you point me to the correct place. I am trying to produce a (dynamic) list of the Top 5 Categories with their Top 5 Sub-categories and the remainder...