Hi all, I have 3 classes with around 60 students in total. I am going to distribute a white shirt to each of them for a group event. The shirts were printed with number on the back (e.g. 1 to 60).

Now, what formula should I use to determine what is the major color in each group?

For instance,

Group A 1 2 5 4 10 Majority:Green

Group B 3 19 7 11 12 Majority:Blue

Group C 13 19 16 14 17 Majority:Blue

Group D 8 9 15 6 20 Majority: Green

1 Blue
2 Green
3 Blue
4 Green
5 Blue
6 Green
7 Blue
8 Green
9 Blue
10 Green
11 Blue
12 Green
13 Blue
14 Green
15 Blue

I am trying to help my wife streamline the workflow of her design business.

Individual Rooms have their own sheet - eg. Club Room, Break Room, Lounge, Cyber Cafe, etc.

Those sheets contain an itemized list of furnishings, cost, budget, etc.

I created a simple rule through conditional formatting to highlight each piece that is over budget (G column is Budget, H column is cost) So the formula was =$H2>$G2, if true the Cost cell is highlighted red.

Hi all,

I'm trying to get a formula working which is able to count days between two dates or provide days since initial consult. This is my current formula (not working). Its been a while since I have to create excel formula.

=IF(K7="blank",DATEDIF(E7,TODAY(),"d"),""=DAYS(K7,E7))

The =DAYS(K7,E7) will count the days between two dates and wokrs well.

The +DATEDIF(E7,TODAY(),"d"),"" works well in counting how many days between a set date and today.

I want to use the VLOOKUP function. The function will reference a different tab in the workbook to return values on the "Main" tab. I have a list of identifiers which are static that I will use on a quarterly basis, so there may not be values for certain identifiers quarter-over-quarter. The VLOOKUP function returns a #N/A if it does not find a match. However, I need to calculate a year-to-date amount on the "Main" tab, but cannot do so because of the #N/A. Is there a way to have the function return a value of zero versus #N/A so the sum formula on my "Main" tab will calculate a number?

Hi all! What formula should I use if I want to determine whether the score achieved by my students falls within the category of "Low" or "High" mark?

For instance,

Class A 1 2 5 4 10 Majority:Low Mark

Class B 6 8 8 19 15 Majority:Low Mark

Class C 16 17 18 20 1 Majority:High Mark

1 Low Mark
2 Low Mark
3 Low Mark
4 Low Mark
5 Low Mark
6 Low Mark
7 Low Mark
8 Low Mark
9 Low Mark
10 Low Mark
11 High Mark
12 High Mark
13 High Mark
14 High Mark
15 High Mark
16 High Mark
17 High Mark
18 High Mark
19 High Mark
20 High Mark

So I have an Excel file with 140 identical tabs with 76 rows on each tab that contain information. Some of the rows, however, don't necessarily contain any useful information so I would like to hide them. Therefore, I wrote a formula in Column A that will show "HIDE" or "SHOW" depending on whether or not I want it to appear.

Then, I wrote a VBA macro to go through all the rows in all the tabs and hide those leading with "HIDE" but the pain point is that this macro takes 3-5 hours and that's ridiculous!!

Hi all,

I'm trying to make a code work (see below). I have a saved excel and powerpoint file. I'm trying to paste individual excel data to individual powerpoint slides, for instance A3 to slide 3, A4 to slide 4, etc. The errors I get is mostly at "oPPSlide.Shapes.Paste.Select": either integer out of range or object is not active/found. What am I doing wrong here? Does it have something to do with the current slide not being active or the shape not defined (enough)?

Thanks in advance for all replies.

"
Option Explicit

Sub Test()

Hello,

i'm making a time sheet for work and i wrote these equations

input : arrival time , departure time , working hours , limit

cell#1 : duration = departure - arrival

cell#2 : deducted = ceiling(working hours - duraion,limit)

working hours = 8:00
limit = 00:15

for some reason when and only when i use these values (9:50 for arrival) and (17:50 for departure)
cell#2 returns the value (00:15) instead of (00:00)

as if (8:00) - (17:50 - 9:50) is more than zero

example in attached file
MS office 2007

HELP

I would require your help in Auto-filling data in specific cells of various sheets using Excel VBA ;for the purpose of computing Balance Score Card for my Team.

I would be really thankful if you can assist me with the same. This will save a lot of my time.

• Data from Master Sheet must auto-populate in remaining sheets, with the Individual Agents names.
• I have coloured the cells for 1st Agent – Akhlaq Khan. Data from Yellow cells (from Master sheet) must auto-populate in Yellow cells (in sheet name ‘Akhlaq’). Similarly, for Pink and Orange cells.
• Similarly, for remaining Agents.

I need help with the following:
I have a column with different colored cells and I need a formula to copy this column in another workbook but I only want to copy the last 6 cells of each color. Maybe the attached example will help you(numbers in cells are random)

Hi All

I hope I will be clear in my query and that someone is able to understand it and assist accordingly.
I currently have an excel document that serves as an Access Control Matrix. In it I have tick boxes for item selection and a button labelled "Submit". I would like the "Submit" to do the following:

1. save and send the information entered on the spreadsheet to a specific e-mail address in excel or csv format
2. clear all tick boxes upon hitting the "submit" button.

Not sure if this would make any difference but the document will be hosted in a SharePoint repository.

I have 1000+ of files (different format than .txt/.doc files).
I need to open these files only in wordpad (so that I can able to view the content).
I would like to extract some information from these files after moving it to an excel sheet.
So for this purpose I need to import whole data from "wordpad" files to excel.

I can able to open my file in wordpad but unable to copy & paste in the required excel sheet.
Please send me the vba code.

Please help me.

Regards
Arkajagar

I am trying to create a list in column A (thatt will be my drop down list) with a description in column B. In a new work book I want to select the item from the list and have it fill the next cell with the description.

Can you offer advice on how to do this?

Thank you,
Jeff

Hello!

I have a question regarding using Cells to name worksheets. I have searched the internet and cant seem to find a code that works.

I have names on some worksheets in cell A1 and i want excel to change the name of the Tab when the name in A1 is change.

Please Advise :)

Thanks

James

Hi, I am trying to change the format of every highlighted/selected cell in a given column. I want to take out an unnecessary "0" using these five steps: 1)=text(cell, "000000000000") 2) Left(cell,5) 3)Right(cell,6) 4) concatenate(left 5 and right 6) 5)value(the concatenated text)

I want to be left with only the column of new numbers (with the deleted "0").

This is what I have so far, and it is not working like I want it to; it will do the proper steps but only to one cell...it deletes any other cells. I am very, very new to VBA.

Thank you for any help!

Sub NDCswitch()
'

Hi i am new to all this so i apologies if i have trouble explaining myself. I have a spreadsheet with lots of drop-down lists which are imported from a table. In the table at the moment are number e.g. $390 What i am trying to do is instead of showing $390 in the drop-down list i want it to say Before 2pm. Obviously i still need the formula to work. Been to the Microsoft Store in Sydney and i am a novice and i knew more than the advisers who work there very frustrating. They keep saying this is beyond Excel capabilities

Hi All,

I'm stuck on a spreadsheet I'm creating and wondered if someone could help.

I have a list of 192 countries. This list is definitive and used for all clients however not all clients will have a value in each country.

What I want to achieve is a lookup that only shows the countries that have values.

I have tried NestedIFs but I can only get it to find the first country ad none subsequently. Given that there are so many countries, the formula gets horrendous too. I've tried VLookUp but again, this needs to be done in a way that I would have a list of 192.

Hello,

I have two questions:

1. In column A I have data (163 rows) with billion and million (It looks like this: 1.11B, 670.93M). I want in colum B to convert everything billions. For example 1.11B to remain 1.11 billion, but 670.93M to convert to 0.67B. Which formula to use it?
2. I want ot use Conditional Formatting to color in green column J if data entered is bigger from column K and L (If data is bigger only from K or only from L, not to colored)

Thank you

I currently have an excel source workbook that contains data in some of the columns that needs to be copied to specific columns in a target workbook where the column names in the target workbook don't always match the column names in the source workbook. Basically, I need a macro to map that columns in the source workbook to the specified columns in the target workbook. I can have both workbooks open at the same time when the macro is run.

Hello,

I need some assistance dealing with comparison of ranges in my workbook. What my goal is to be able to check Sample 1 against the data field and if it's not present check Sample 2 against the data field and return that text value. I've provide an sample spreadsheet within this post. I've tried If statements, Vlookups, and even Index and Match and I still cannot seem to get the desired results. Any help on this would be greatly appreciated...

Thanks

Xcelhelp87

Hi I want to change the last character in each cell in increase alphabet down a column, for example in a column I have

1234A
1234B
1234C
1234D
etc

How do I use a formula so that I can hold Ctr+Down to fill down the column while it automatically changes the last character in alphabetical order (A,B,C,D,E so on)?

Thanks!

I hv a long sql cmd in one cell in excel. to copy paste in ISPF screen I want to split this cmd in 3 cells one down after other. I am attaching the JPG image. In that you can see a image of before splitting and after splitting...this I did manually. But since 1000 more data like this to be splitted ans doing it manually is very hectic. So looking for some formula after which I can get a data like a image of 'after split' in a next sheet.

I am also attaching a excel file for which I am looking for data split. Please experts help me in achieving this.

I need to make a formula that fallows this format

IF inventory is _____than this much% of a item that needs to be pulled
<20 100%
>20, 50%
>50, 30%

I need to pull virtual locations and items. This is a small example of a sheet i have to work with. But I can only pull so much of one item. I need a way to filter out a subtotal of one item so I don't end up pulling too much of one item. I know there has to be a easier way than tedious process I have been doing it.

currently working on a classified project which involves specific data calculations. I'm stuck with trying to configure the code so that I could get it to work with other samples within that one file. I currently have the code working for 1 sample.

Good Day,
I know the solution sounds simple but it can be risky.
We have an excel document that has name, address, phone number ect and we need to extract the phone number, and send it off to have it compared to a external DB, that is simple and done. Once back there will be the numbers in column A and a "y" or a "n" in Column B. We then need to delete all the numbers with a "y" value and import the "n" back into the original File removing all the rows that are not in the list with a "n" in it, these must be relevant to the original number with contact details.

Hello,
I assist an organisation called Hatzola. Hatzola provides voluntary emergency ambulance services.

We have a volunteer who restocks the ambulances every day. I have implemented a Google Form where the volunteer would log into and submit all fields, the results get loaded onto a Google Spreadsheet. My issues is that out of the 50 checks, 2 to 3 need seeing to and wonder if there is any way to apply a filter that should sort the fields according to the items that require attention.

Please see link below to spreadsheet

Ok, to start with I am not an excel expert at all, so this may not be a challenge at all. Here is the situation: I just got given a new collateral duty in my unit that requires a whole lot of weekly excel crunching all for one specific end: tracking who has filed their paperwork for coded events they completed. I was handed down a sort of cobbled together set of excel files that take two databases and compare them. The first database is a computer output that tracks personnel in the rows, and the columns are coded event numbers.

Let's say I have a list of countries in my drop down list. Is it possible to spell them all out in the list but when one is selected, an abbreviated version appears in the cell?

For example, if "United Kingdom" is in my list, when I select "United Kingdom", I want "UK" to appear in the active cell. If there code I can reference to make this possible? (New to VBA & Excel in general)

Thanks!

Hi,
Any body can help please.
Need an excel button coding , on click of which first 3 inputbox will ask three different numbers from user and will put these numbers in A2,B2 and C2 respectively then in cell D2 will put the greatest no ,E2 - smallest no and F2 will put Yes if they all are equal else no if they are not equal.
Also will change the font/Colour of greatest no to RED/BOLD and smallest number to GREEN/BOLD.(in cell A2,B2 or C2),
If button clicked again will put the next series in A3,B3 and C3 and so on(should not override previous filled cells.)

Hi all, I'm new to the forum so apologies if this question has been raised elsewhere but I have been unable to find an answer.
I'm working on an excel document that I would like to save, rename into a predefined location at the click of a button. The document will have a master file name associated to it but would like this to be overwritten. The file name would need to take information from 3 different cells from one worksheet, one of which being the date that the document has been edited using the =today().