Mark A Thread Closed?

Feb 13, 2009

how do i mark a thread closed? I looked in tools and lots of other places?

View 4 Replies


ADVERTISEMENT

Pull Only Date From Thread?

Jul 11, 2014

pull out just the date from this thread: 01/01/14 0919

View 5 Replies View Related

Card Count Thread

May 7, 2009

btw i saw following soloved post but i didnt get the question and answer.

can u provide examples?

http://www.excelforum.com/excel-misc...ard-count.html

View 2 Replies View Related

Keyword Finder - Using An Old Thread For A New

May 5, 2009

I am similarly interested in using the logic in this thread http://www.excelforum.com/excel-prog...uplicates.html

Basically I want to be able to type in a keyword and then bring up a number of matching results along with their associated code.

Using the spreadsheet in the above thread, I tried to add an extra entry as a test, as my database contains roughly ~1500 entries, but excel doesn't seem to like me adding 1 more entry and adjusting the dimensions of the code?

View 2 Replies View Related

How To Attach A File In New Thread

Sep 22, 2013

I have found no option here to attache file (excel, or word if any). How to attach file in to create a new thread ?

View 1 Replies View Related

Position Of Latest Thread

Nov 4, 2009

XYZ001

XYZ002XYZ003

XYZ004XYZ003XYZ004XYZ001XYZ002XYZ004

I have data in above format (including Dup). Is there anyway I can get the postion of latest entry. say if it is xyz011, it should return 8. Match will start counting from first cell and go downward. How can do a inverse counting?

View 9 Replies View Related

Survey Form - How To Open Another Thread

Jan 2, 2013

how to open another thread. I would like to do a survey form (as attached) but I wanted to use VBA to make it easy to compute the result.

View 2 Replies View Related

Change A Thread Message Format To Html?

Jan 11, 2009

If it is possible to do, how do I change this message format to html so that I can paste an image into the message?

View 5 Replies View Related

Copy Range From Closed File & Paste To Closed Workbook

Apr 26, 2008

Is there code that will take certain data from one Excel sheet to another named file in a different place on the network? Example Copy cell aa47 from "Recent Faxes.xls" that sits in "correspondence" folder. Then paste into cell B25 "Current Documentation.xls" in the "Sales Contacts" folder

View 2 Replies View Related

Mark Up Formula

Oct 1, 2007

i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price

to work out the retail price i need to sue this forumula

retail price = wholesaleprice + x% of wholesale price

im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!)

View 10 Replies View Related

How Do Mark All Posts?

Feb 26, 2009

how and where to navigate on the website to mark all my posts solved. Sometimes I don't see the edit button, I don't know how to list all my posts, etc.

View 5 Replies View Related

Look Into Another Workbook And If Value Is There - Mark As Yes

Jul 22, 2014

I have two workbooks, lets say book1 and book2

In column A of book 1 i have a list of numbers, going down to A250

A1 = 23423423
A2 = 23442345

etc etc

I would like some code for a button press, if the value in A1:A250 is in book2 (A1:A250)

Both workbooks will be open at the point of the button press

then adjacent cell in B1:B250 is marked as Yes

View 5 Replies View Related

Character Mark In A Box

May 23, 2008

I've searched for this in the forums but can't find anything. I need to find/replace a character in Excel, it's a question mark in a box and looks like this

I've tried searching for special characters (using the ALT key and number pad) but I can't find anything matching this.

When I save the spreadsheet as a CSV (TAB delimited) this character gets picked up as a TAB, but when I try find replace on the TAB character it doesn't work!

I'm using Excel 2007.

View 9 Replies View Related

Find And Mark

Mar 16, 2009

I have to manually enter the code nos. of the hard copy to find the code in the soft copy. After finding the number, I wish to mark it as so that double work should not be done or to find which code's hard copy is not with me.

I am using Find and Replace to find the number and after it is found I have to click the replace tab to enter colour in it.

Is there any auto function to mark as soon as I find the required number instead of clicking the replace tab to save my time.

View 9 Replies View Related

Mark Cell By Column And Row Value

Feb 2, 2014

I have the following formula and need to incorporate that it is only a "B" if B20 also matches in named range "Breakdown_RSC"

Formula: ...........

I need the following section to take into account the data in B20 as in if it matches the data in the cell it should be a "B" in the cell.

View 2 Replies View Related

Mark Intersection Of Two Items?

Mar 3, 2014

I am making a rough gantt chart in excel for a project schedule. Japanese at work love excel fro some reason that is why I am trying to do this. I have column headings for days ( 3/3, 3/4, 3/5, etc) and I want to find a way to mark the intersection when a date is input in another row. I tried to do some conditional formatting using symbols, but couldn't get anything to work.

see picture. I want to mark at correct date according to column headings when date is placed in column E or F. This example shows column E with 3/10 so I want to make a value appear at intersection AS and the row 3/10 is on. Would like to get a symbol to appear there if possible.

excel help.png

View 5 Replies View Related

Click And Mark A Cell With An X

Dec 18, 2008

Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?

View 11 Replies View Related

Mark Dates With Colors

Nov 22, 2009

i want to know how to mark the cells with color where the starting date is not greater than ending date.

View 4 Replies View Related

Mark Repeating Field

Dec 27, 2008

I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated.

So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. How would I go about separating the duplicates (to then delete them)?

It's sorted by address then consumption. The logic is...

if the address value in column A repeats and the consumption field in column B also repeats, then...(place a marker in column C so I can sort and delete)

View 2 Replies View Related

Cost Based Mark Up

Sep 26, 2007

set up a cost based markup spreadsheet?

I need to be able to mark up values from 0.01-9.99 by 20% of their value, and 10.00 and above by 10% of their value.

I only know how to mark up values by a single percentage.

View 9 Replies View Related

Find And Mark Duplicates

Dec 16, 2008

I need to find duplicates subnet information in row F and mark the words "Duplicate"
Then I need to do the same with Row K. I need to find any duplicate subnet masks.

The reason for this is that I merged two orginizations into one spreadsheet and I need to find the duplicates in Company A and Company B's subnet and mask information.

View 9 Replies View Related

Mark Formula Cells

Aug 14, 2009

I have a problem - I wanna to mark (to colour) just cells which I use in formula is there any option for thise

If I have some table and I have formula =A1+B5+C7 I wana to colour just mentioned cells

View 9 Replies View Related

Check For And Then Mark Duplicates

Aug 24, 2009

I have a simple spread sheet, as shown below. Each line is on it's own row, and all the info on each line is in the first cell. (A1,A2,A3 etc....) What I require is a macro that will look at the "Code" line, take note of the code and if it finds a duplicate code number, mark the duplicate code with (1)....say up to (5).

In the case below, it would flag the second 07edr code and change it to 07edr(1). If there was a third 07edr code it would mark it 07edr(2) etc.

It needs to look at all the codes as it's possible there will be more then one set of duplicates.

Description = item 1
Code = 07edr
Quantity = 1
Description = item 3
Code = 08geo
Quantity = 2
Description = item 78
Code = 08cpm
Quantity = 1
Description = item 1
Code = 07edr
Quantity = 2
Description = item 39
Code = 16blf
Quantity = 1

View 9 Replies View Related

Check Mark In Cell

Aug 22, 2007

I inserted a check mark and tried to us a vertical lookup and post the check mark
All I get is a horseshoe looking character. When I do reference to the cell I get the same symbol. What I trying to do is to place a check mark by the items which have been approved. I know I could do it with an "X" or a color, but top management wants a check symbol. I am using Excel 2007

View 3 Replies View Related

How To Mark All Rows Which Fall In One Of Ranges

Aug 15, 2014

I have about 50 timespans.

Each is formatted to have start time in column A and end time in column B (DD/MM/YY h:mm).

I also have a list, with about 850 rows timestamped (same format).

I need to mark all rows which fall in one of the ranges.

View 2 Replies View Related

How To Click A Cell That Will Automatically Mark With X

Jul 17, 2014

I am creating a resource and I'd like the users of this resource to be able to click a cell which will then automatically come up with an x or similar symbol (tick?) and then if they click the cell again the x will disappear. Is this possible? I don't want a drop down box where they have to choose what they want, I want it to be an automatic action when the cell is clicked because there will be many cells that I will need to do this.

View 14 Replies View Related

Macro To Mark Up A Complete Column By 10%

Dec 18, 2008

i have a excel file i need to markup by a 10% value. It is the L column starting at row 2 till a varying number of rows. i need to mark up all of the rows in the spreadsheet. i do not know how to make it repeat.

This is the formula =L2*1.1(i think its the right one) but i do not understand how to make it repeat. any help would be greatly appreciated.

I need the value to be replaced with the marked up value.

View 8 Replies View Related

Joining Two Cells Data With A X Mark In Between Them

Jan 28, 2013

i have two entries in my excel sheet which i want to get noted in the other cell as follow

A B
1 ORDER NO. 480
2 GOODS 5
3 P.M 480X5

as my table have data in B1 AND B2 so i want B3 automatically becomes 480X5 so how can i do it

View 2 Replies View Related

Comparing Columns And Mark Difference?

Oct 30, 2013

When comparing collumns to find out if the values are the same or different I use this formula:

=IF((A2)=(B2);"same";"different")In some cases I see the results are not OK. I see the same values but the result states "different". This might be caused by spaces around the value that does not exist in the other cell I think.

File is attached, the green marking show what I expect to see, the yellow marking shows what puzzles me.

View 11 Replies View Related

Using Cell As Checkbox (add Tick Mark)

Nov 13, 2008

I need to click on a cell and when I click on it, it should change colour and insert a tick (or other symbol).

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved