0.0px

Hello, i have the following code i want to use for a button. It will random;y work like sometime when i open the sheet but then i start getting error codes like <style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #006107}span.s2 {color: #ab30d6}span.s3 {color: #a54a29}span.s4 {color: #0057d6}span.s5 {color: #33af4a}span.s6 {color: #ff9c1b}</style>Hi, I have an issue where my LARGE...

Hi all, I'm using two Index Match formulas in adjacent cells. They are slightly different as I want them to return a value from different ranges, but they are written in exactly the same manner, yet one works and one doesn't. This works: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px...

Hi, I'm wondering what's wrong with my AVERAGEIFS formula: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color...

Hi, I created a spreadsheet with a number of different formulas. To create and test the formulas, I used a small sample size of data. Now complete, they need to be used on a large range of data (will be up to 7000 rows when complete), however it seems that as I increase the data size, the...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #006107}span.s2 {color: #ab30d6}span.s3 {color: #33af4a}</style>Hi, I'm wondering how to combine the following into one workable function: <tbody> U V W X Y Z 134 LL...

Hi, I am trying to match a value that might appear in one of two columns. My working in english is this: IF (Sheet 2 Column D = Sheet1 A2) AND (Sheet2 Column A = Sheet1 H1) INDEX (Return value from Sheet 2 Column C) OR IF (Sheet 2 Column C = Sheet1 A2) AND (Sheet2 Column A = Sheet1 H1) INDEX...

Good Evening I am trying to call a code when a value appears in a column. I am trying the code below, but it works every time the value appears. I just want to call the code once if, say "4W" appears in the column. "4W" may appear multiple times in the column. Is there some way to return a True...

Hi, I am using the INDEX, MATCH combination with a number of criteria, but am receiving an incorrect result. In plain english, here is what I am trying to do. The formula is entered into "Sheet2" column D. The value I wish to return is an average of "Sheet1" column Q. Based on the following...

Hi, Really need some help with trying to work out a formula. I have created an excel spreadsheet which includes the table included in the link below (Table 2. A DIF Analysis Algorithm on page 35 (41/393)) of the following pdf: <style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px...

Hello, I'm very new to the VBA world but was able to get my code to work on every workbook that I manually add it too. The code is really simple to just add message boxes before closing the workbook that serve as reminders to myself. <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px...

Hello, I'm having trouble trying to display results from a different sheet where my raw data is when I try to combine two COUNTIFs. The 1st one works and gives the correct value but when I try to add the 2nd I get an incorrect result. I want a total of when the value in the 1st column is...

I have a dataset that looks like this for 1400 rows: <tbody> Buy 273 Buy 263 Sell_short 340 Sell_long 209 Buy 271 </tbody> When the left column is buy, the right column gets added to the account. When the left column is sell_short or sell_long, the right column gets detracted from...

I have this Sub that I get exactly what I want, but I want to make it a function so the the "Team" Variable can be a cell that I select. Here is the Sub code. Option Explicit Sub MYCOUNT() Dim Team As String Team = Range("BC7") Dim rg2 As Range Set rg2 = Sheets(1).Range("C5:AR5")...

hi and thanks for reading this and wanting to help me i am trying to upload product on google merchant/google shopping and mu upc formatting in a csv file keeps erroring - i keep getting an error message - Ambiguous GTIN code - sooooo frustrating! can anyone give me some help / advice on the...

Hello, I'm new to writing macros and have not been able to make much headway using online instructions or youtube. I have a few hundred excel files, each containing 3 worksheets. I'd like to pull data from a specific worksheet called "Physician Results" and have the data compiled into a single...

I am new to VBA. The last lines of the recorded macro shown below show an absolute reference for a Fill Down operation (C448). I would like to make the reference dynamic - filling to the last row in the sheet rather than the fixed reference. How should I modify this macro to do this? Thank...

Hi All, I'm trying to print PDF files from a specific sheet within excel. The below code works perfectly on a Windows machine but I can't get it working on my Mac. Everytime I run, I get an error code (1004). Do I need to edit the code to be compatible with Mac OS? Can anyone spot any glaring...

Hi The below code copy and pastes info from sheet "Csv" and saves it onto a mac desktop as a csv file. The sheet "csv" has a filtered area, if I use the filter to select some rows the code only copy and pastes and saves those rows, but when I 'select all' from the filter box the macro below...

Ok, so ive two sheets. On sheet1 i want to enter a value which will then be queried in sheet2 and if matchning values are found then unique values be listed accordingly. For example: Sheet1 should look like this: <tbody> A B 1 Search xyz 2 3 Unique values bob 4 john </tbody>...