question

I have a set of data with different groups ("colors"). For each group (color), there are questions that apply to "categories" ("A", "B", "C", etc.). Each has a numerical score. I need to pick the highest scoring question for each category, for each group (color). Example: Group "Blue" has 2...

Hi! I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so? Hope you can help, thanks in advance!

Sub Email() Application.Dialogs(xlDialogSendMail).Show End Sub so I have found the emal icon and put it on the ribbon.Even managed to record it in a macro. The Million dollar question can I get the TO option to fill from Cell A on SHEET1(which is email address)

Hi I have a table like the one below. I want to highlight empty cells to delete them etc. I went to GoTo Special, and clicked on Blank Cell but excel highlighted the cells inside the table and SOME outside the table too. Why excel highlighted the outside cells. To fix this issue, I had to...

Hi - I am a noob and this is my first post / question - hello to everyone I am merging two tables together with the first column of each table being matched. The problem I am having is that when they merge together I loose the order of the first table. How to I merge then together will...

I have a button that grabs data from several fields, formats them, puts that text string into a new field and copies it to the clipboard with the docmd ac.copy (not at that computer right now so the command may not be exactly right). My question is, rather than go through the step of pasting...

Hello all, First time Poster here, and novice in coding in general. My issue I am having is more a question of knowledge I feel. I am looking to scrap a java-script table on a secure site. So far I am able to log in but to get to the Data I want. There is a few buttons and links I must click...

Ok, im very new to Microsoft Access. My database knowledge comes from trail and error on SQL databases for Forums Like "PHP FUSION" I can pretty much do what ever i want using the sql command box. SO for my very first newbie question out of many to come im sure! Can you use sql santax in Access...

I have a table that has a range of cells in it <tbody> a b c d e f g h i j k l m n o p q r s t u v w x y 1 12 18 47 2 72 67 67 3 70 45 45 56 4 34 56 5 56 67 6 total...

Hi all I just want to copy a cell (A1) value down to A2. Only if B2 has a value. And so forth, copy A2 to A3 if B3 has a value. Thanks in advance, ColdGeorge

Good Afternoon, I've always had luck in this forum, hopefully my luck continues. I have column c filled with the results of a formula (date difference expressed in number of days). What would the formula be to change column C to: 1) If less than 14 days, display "0" 2) If greater than 14 days...

this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value" example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the...

Hi, I'm trying to calculate monthly returns from daily returns using geometric mean. I would like to be able to check the date array in column A of the attached document and locate the corresponding return array if the month and the year of the dates in question are equal to the month's returns...

Hi. On sheet2, I have a load of questions & answers from a survey. Row 90, Columns D and E contain Yes and No respectively as the answer options, with a tickbox in each cell, one of which is ticked for each question. On sheet1, I want to enter in cell b2 a formula which will return the result...

I have a excel question: Is there a way to count the number of times a number repeats in a string before another number replaces it. I am talking about consecutive repeats within a string such as below. What is the the longest run of 3 at any one time? 3 3 2 2 2 0 0 0 0 0 0 3 1 1 1...

Hi everyone, I have a question for creating a formula for conditional formatting. In cell A1 has a value 001 In cell B1 has the value 00 I would like to highlight cell A1 if the 1st 2 digits 00 are the same as cell B1 00 Color = Yellow Thanks

hi guys i have a question about my userform i got 1 command button and 16 textbox. the textbox 1 was the one that i use to search the data and display it to other textbox. is it possible to textbox1 to search only the last 3 digit number instead of 8 digit? wish some can answer my question...

I have tried to post a question with a couple of lines of example, but it only posts the first couple of lines -why?

Hi, I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw...

Might be missing the obvious but need some help. I have this data that I extract from a SharePoint survey and dump into excel. The questions all have various responses and the report is becoming tedious to maintain. I want to pull the highest response, second, third for each question. When I...