good

Good Morning: I am trying to utilize the following If And formula but it doesn't seem to be working. =IF(AND(O8>="95",<="100","25",IF(AND(08>="85",<="94","20",IF(AND(O8>="70",<="84","15",IF(AND(O8>="50",<="69","10",IF(AND(O8>="30",<="49","5",IF(O<="29","0","null"))))))))))) I am trying to...

I am trying to create a spreadsheet that keeps a running tally of totals for the day. What would be a good formula for that?

<tbody> First 1000 is 10 then plus every 1000 is 1 until 10000 After 10.000 every 5.000 until 100.000 After 100.000 every 10.000 1300 11 0 0 2300 12 0 0 7,800 17 0 0 17,800 20 1 0 22,000 20 2 0 35,500 20 5 0 85,000 20 15 0 103,000 20 18 0 145,000 20 18 4 </tbody> Good day...

SQL_tblEstReqs_Remove = "DELETE * FROM tblEstReqs WHERE (tblEstReqs.EstNo = '" & tempEstNo & "') AND (tblEstReqs.StartDateAEMIS = #" & tempstartAEMIS & "# ) AND (tblEstReqs.EndDateAEMIS = #" & tempendAEMIS & "#);" I think there is a better way i could do this, im not very good with VBA + SQL :(

Good morning all Im a bit stuck trying to get information from a pasricular website. please see below a page from the website. http://greyhoundbet.racingpost.com/#result-meeting-result/race_id=1015910&track_id=7&r_date=2010-03-12&r_time=11:03 My problem is im trying to obtain the traps...

Hi all I was wondering if anyone could help me out with a problem. I have about 1,500 word documents with tables that represent student evaluation. It is a tick box exercise where we have very good, good, needs work. I was wondering if it would be possible to make some VBA code that opens each...

I have a large data dump I get. I need to write a macro that filters data and copies it to another tab in the workbook. I’m not good with writing my own macros. I’m good with recording and editing. But my skills with VBA are limited. Also, any great beginner tutorials for writing VBA? Would...

Good afternoon - can someone please advise as to how I can do this? Regards Pete

Hi I have forgotten how to do the HTML stuff. I have tried to download a HTML fie ad ended up with a spreadsheet, but dont know how to find the Mr ExcelHtml menu. I downloaded the old Jeanie but it was incompatible. I am using Excel 2016. Any help would be graetly appreciated. Keep it simple and...

I have categories in Col A and a corresponding rating in Col B. Col A is dynamic. Col B is fixed to:Avg,good,new, or null. Not all categories will have ratings (null). I am trying to group the categories by ratings - with specific formatting. See below. Desired result is in B10...

Hi , I have the look up table below <tbody> A B C D E STATUS YES YES GOOD NO NO FAST BAD </tbody> <tbody> </tbody> i have a table of data below and i need to pick the correct status based on the rules in the look up table. <tbody> name A B C D E STATUS craig yes yes no no...

hello, i made code: dim x,y as integer for i = 1 to 5 for j=1 to 5 cells (x,y).select selection.lock next j next i the command "selection.lock" is not good. what should i write instead?

Sorry if the title is a bit obtuse...little hard to explain. I'm trying to come up with a single sum formula that evaluates each cell in a column and adds a specific value to the sum based on the contents of that cell and two other cells in the same row. Here's an example table: <tbody>...

I am sure this is easy for most of you, but I am struggling. I would like to put 2 IF Functions in one cell. I started with this and it works fine: =IF(A12="X",1,0) I would just like to add that IF B12 has an X, then it would equal 1 as well. Either A12 or B12 will have an X, never both...

Hello, I am sure this is an easy question, but I have not been able to get it to work for me. I have 5000+ rows that can contain both numbers, alpha and a mix of both. The column is formatted custom '000000000000000' (15). What I need is if the cell contains anything other than 15 (no spaces)...