Loading...

Follow Excel Help Forum on Feedspot

Continue with Google
Continue with Facebook
or

Valid
Keto Elite Diet Shark Tank Reviews is a supplement designed for weight loss. The working mechanism of this supplement is based on the principle of ketosis. The basic way that it works is as: Firstly, the supplement is absorbed into your body. When you take in the supplement, it goes into your blood stream from where it is taken to rest of the body.After that, it starts to show effect and that effect is taken to the rest of the body.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Anyone knows why my formula does not work ? Thank You

Error.png
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel form allows 32 columns, is there a workaround to have 40 columns or more?
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi

I want to extract the date from the 3 criteria column with a condition stated. I have managed to extract the date for each column based on the condition using the formula as shown below.
Is it able to just use one formula to find.

Screenshot_1.jpg

INDEX(DATES,MATCH(0,IF(G$1&"TRUE"=C$2:C$9,COUNTIF(G$2:G2,DATES),""),0),0)
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi

I would like to know if it is possible to replace a reference number in a chart series to a cell reference.

Example =$C$(cell ref):$H$(cell ref)

The plan is to be able to select from a drop down menu and be able to plot a different row based on the request.
Thanks
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

I'm trying to use VBA to hide columns based on todays date.

For example: If todays date is the 22/6/2018, I would like it hide all columns before this date.

I think its a little different to what i have searched in google since my date format is not in dd/mm/yyyy... but rather either d , ddd or dddd

I have attached spreadsheet
Attached Files
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

I am trying to create product codes and descriptions for products in our retail store and the items have multiple variables.

I wanted to see if there was a way i could put in the variables (colour, material, size, etc) and have excel create all possible combinations of these for me along with a shortened product code based on the variables.

For example:
Variables = |Blind | White, grey, yellow, blue | 50mm, 60mm| Installed, Not-installed|
code abbreviation = |B |W, G, Y, B | 50, 60 | I, NI|

So I wanted it to generate the code - BW50I (and the description) Blind, White, 50mm, Installed - for all possible variables (e.g. BG50I, BY50I, BB50I, BW60I, ETC ETC ETC & DESCRIPTIONS)

I may have not explained it well sorry. I know this is probably way outside the boundaries of what Excel is capable of but just thought i'd ask before i create 5000 product codes manually.

Any help is appreciated.
Thank you
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Excel Help Forum by Andrew.trevayne - 6h ago
Hi,
I have this Macro and I wanted the results to display value instead of formulas.
Any suggestions?

Code:
Sub Testing()
        Range("D2:D500").FormulaR1C1 = "=COUNTIFS(Data!C[6],'Report'!RC[-1],Data!C[5],""AAAA"")"
       
 
End Sub
Appreciate any help. Thanks much.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I have another complex (in my mind) Excel formula that I can't figure out.

I first need to do a validation on one column (A) trying to validate if the "CAAA" option was selected...if it was, I need to multiply a VLookup value, multiply it by an exchange rate, and then lastly multiply it by another variable. IF anything other than CAAA is selected in Col A, I simply want to multiple the VLookup value by a separate variable.

My formula is:
=IFERROR(IF(A3="CAAA",VLOOKUP(B3,Table1,3,))*Setup!$B$10,0)*IF(C3=1,Setup!$G$2,IF(C3=2,Setup!$G$3,IF(C3=3,Setup!$G$4,VLOOKUP(B3,Table1,2,))*IF(C3=1,Setup!$F$2,IF(C3=2,Setup!$F$3,IF(C3=3,Setup!$F$4)))))

I know I am running into the issue with VLookup only being able to consider one value, but I'm not sure what other command to use in it's place...or how else to accomplish my task.

I have attached a sample of the file I am working on, which partially works...If CAAA is selected in Col A, the formula successfully runs as long as a value or 1 or 2 is selected for Col C (if a value of three is entered, there is an improper calculation made (probably because a new VLookup follows this option. IF anything other than CAAA is selected in Col A, the formula returns a "0" (I'm assuming a result of error checking).

Any help would be appreciated.
Thanks,
Bill
Attached Files
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
On the attached document, I am trying to have the columns: Part #, Description and Cost of the table in sheet "March" automatically populate with the data from the corresponding columns in the sheet "Running Total", but only the ones that fall into the date range specified in the sheet "March." I need to do this without a macro and if possible no VBA formulas. I will be using a macro later on to remove the duplicates that will exist as more and more data is entered into the running total sheet.
Attached Files
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview