Formula To Show Users Name

Apr 5, 2007

Is there are a formula that will result in showing the users name in a selected cell?

View 9 Replies


ADVERTISEMENT

Show Users Only Certain Data Based On Their Name

Sep 29, 2006

I have a large workbook that contains markbook info of all my classes that I teach.
I don't want them to see all my workbook as it would be too confusing. I would like to hide all the data and have a simple INPUT box on a separate page that would ask for their name. The name would then be used to find the row number, add this to a specific column number (always the same) which hold their marks and then return the mark in a Message box.

View 2 Replies View Related

Users Of The Spreadsheet Cannot Delete The Formula

Feb 6, 2009

I have this formula in my worksheet

=sum (L12*M12*N12)

How can i put this formula into VB code so that users of the spreadsheet cannot delete the formula.

View 9 Replies View Related

Pivot Tables & Formula: Build A Pivottable And Let Users Move The Fields Around

Apr 28, 2007

I'm trying to do at the moment is build a user interface for some Excel Data. Now, the natural way to do this would be to build a pivottable and let users move the fields around, and this is how the thing has worked in previous iterations of the workbook. It seems now, hoever, that we're trying to cater for users for whom pivot tables are just a little too much and to summaries data based on listboxes etc.

What I'm interested in knowing is whether there are ways of interacting with PivotTables beyond the GETPIVOTDATA function - is there any way, for example, to select different field items to show based upon an input from elsewhere? How does one tell a pivottable what to do from outside the pivottable?

View 3 Replies View Related

Formula To Show Formula From Another Cell?

Jan 14, 2014

does such a formula exist? I regularly Change a formula in cell C1. To Show my working I would like to have The formula from C1 written next to it as an equation.

Example: B1 | C1
=Text"updated from formula in C1 automatically" | =x+y*A2

Summarised, is there a formula to Display the formula written in another cell?

View 2 Replies View Related

Getting A Formula To Show Zero Until It Is Used

Aug 4, 2009

I have used excel to create a set of timesheeets and a total page, on the total page there is a column that will show you any varience on your hours each month (I.e if you have worked overtime or under your hours)

I have used the formula =(worked+hours+sick)-(weekly hours*week in month)

This works fine the only problem is in shows a minus number until the hours for that month have been entered so I cant create a total column, is they any way to get these numbers to show 0 until the times are entered?

View 14 Replies View Related

Formula To Show The Numbers When They Are Below 30

Jun 4, 2009

I need a formula to show the numbers as they are when they are below 30, but when they go above 30 I need it to display 30 every time. I have attched a file.

View 3 Replies View Related

Show The Formula In Cell

Aug 23, 2009

I'm trying this code but its not showing the formula in cell Z1, what am i doing wrong here ??

View 2 Replies View Related

Formula To Show A Change In A Row

Aug 24, 2007

I'm working through a huge file and trying to compact it down and make it more workable. I've already managed to get it down to what i need but i now need to add a few things so others can work it more easily also.

One of the ideas i had was the following, but for the life of me i dont know where to start.

The spreadsheet will be updated on a daily basis and at the end of each week we will need to submit any changes we've made to the marketing team.
However the change tracker thats built into excel isn't really what i want.

What i though was i should set up an IF formula that would return a True value if any data in that row was changed.
Then i could set up a macro to copy those rows only to a new sheet to be sent to the marketing team, this way the structure of the spreadsheet would be kept to make it easier for them.

View 9 Replies View Related

Show Formula As Text

Apr 25, 2006

show a formula as text in another cell

View 5 Replies View Related

Only Show Formula Result If Not Zero

Nov 7, 2006

I'm having trouble with the attached example. An earlier member solved the odd-even problem, but I'd only like it to calculate if there is data in columns B to G.

View 7 Replies View Related

If & And Formula: Show The Difference Between Col F And Col G

Mar 14, 2007

if the cells in column E AND column F are blank, then column G will be blank also (I dont want 0 showing), if not show me the difference between col F and col G.

I put in the following:-

=IF((E2="")AND(F2=""),"",E2-F2)

However, Excel informs me this is wrong and corrected it as

=IF((E2="")*AND(F2=""),"",E2-F2)

I guess my question is why do I need to put in "*" for this to work?

View 5 Replies View Related

Show Copied Formula

Sep 7, 2007

I have a problem in copy formulas form one cell to another, my formulas are writen in one workbook in this way... '=Dog+Cat.

The problem is that I did a looking table code (vlookup) and when it shows the formula I have #¿Name?.

I would like to knw if there is a way to fix this using the vlookup or I'll be obligated to use special Copypaste

View 8 Replies View Related

How To Show Minus Value In A Formula As Plus Sign

May 31, 2014

I have attached here an excel sheet with some data. I need to show the minus value in D5 as a plus sign, is there any conditional formula to work this out??

View 4 Replies View Related

Formula To Show Words In Column?

Dec 16, 2013

Excel. Let's say this how a column looks like:

a
b
b
c
d

Is there a formula to get this outcome:

a 1
b 2
c 1
d 1

If not, is there a way to create a list of words that are in a column?

View 6 Replies View Related

Create If Then Formula That Show Value Of Cell In E8?

Jan 29, 2014

I am trying to create an "if,then" formula that shows:

if cell E8 is greater than 171, then i'd like cell E9 to show the value of cell in E8.

View 6 Replies View Related

2 Cells On A Form - Formula To Show If Then

Mar 17, 2014

I have a list of customers and each customer has a commission value tied to it. I have a form and in it I have a cell that has a list of customers that someone can choose from a drop down list. If a certain customer is chosen I need their commission value to show up in another cell. example: How do I create a formula to show if Company A is chosen in cell G4 then the commission is 5% in cell G38 , If Company B is chosen then the commission is 8%.

View 9 Replies View Related

Formula In Cell Show Blank If Zero

Jun 4, 2009

I have a spreadsheet which imports data from worksheets week 1, 2 etc to a monthly summary.
Is there any way I can show a cell as blank if the return equals 0?

I'm sure the resolution is probably simple but then so am I.

View 6 Replies View Related

Formula To Show A Blank Cell When A SUM = Zero

Oct 29, 2009

On my spreadsheet i have 4 columns which are in currency format. The 5th column (total) adds the 4 up which currently looks like this - =SUM(BG44:BG45) this shows £0.00 in the 5th column.

What i need is a formula in the 5th column (total) so that when it adds up the 4 previous columns if the sum = £0.00 then the total column should show a blank cell.

View 3 Replies View Related

Formula Doesn't Show The Date...

Jan 26, 2010

I m writing this formula in a cell but i dont receive the result i want...

Formula used... ="Program "&""&G2
(G2 is a Date)

This is te result i get...Program 40210

This is the result i want...Program 1-Feb-2010

View 2 Replies View Related

If Formula: Show Only What I Need Instead Of Negative And 0 Balances

Oct 12, 2008

fix my (if formula) so it includes data from sheet 2. Sunday and monday values change but every other remains the same. I was given this formula and cant seem to add to it. Also is there a way to show only what i need instead of negative and 0 balances?

View 2 Replies View Related

How To Use RIGHT Formula To Show Value Until Capital Letter

Dec 29, 2011

I was wondering whether it is possible to find a formula in Excel that would extract (using RIGHT formula) surname from Name Surname cell despite surname lenght i.e.:

'John Smith' in one cell would give 'Smith' in the other
'Tom Let' in one cell would give 'Let' in the other

I have tried to combine RIGHT, FIND and PROPER (for upper case) in one formula but it does not work.

View 2 Replies View Related

Formula To Show Target For Today?

Jan 18, 2012

What i have in cell D3 is the formula 'Today ()' to show the date formatted like so. January 2012.

In cells B1,B4,B7,B10,B13,B16,B19,B22,B25,B28,B31,B34 are results showing targets for set each month of the year (B1=January, B2=February etc). What i want to do in cell D4 is show the target for the month that we are in, in other words the target for the month showing in cell D3.

View 2 Replies View Related

Array Formula Do Not Show Duplicate

Sep 6, 2007

I have a range, 2 columns * 5 rows, populated with numbers.
I want an Array formula that it gives back
SMALL (Range, 1) ......
SMALL (Range, n-m), but WITHOUT DUPLICATES

n= 10 , m = # duplicates

¿FREQUENCY, OFFSET.....?

View 9 Replies View Related

Code To Show The Formula In Comment

Apr 7, 2009

i need code to write the formula in comments

for exampe :

when i insert new formula give me the formula in comments. can we do it?

View 9 Replies View Related

Show Below That Formula Cell In Two Rows

Feb 10, 2010

in my document column "L" have some formulas,it's like this.
=150*1.5+25*1.5
i need to make that formula to two part.it's like this.
=150*1.5
=25*1.5
that two part need show below that formula cell in two rows.

View 9 Replies View Related

Show Formula Result Only If Positive

Aug 23, 2006

Is there a way to have a formula return only positive numbers? basically if the result is of this calucation (B4-(B3*B6)-(B6/2)*0.125) is >0, then return the result, if not return "" (or 0).

View 6 Replies View Related

Formula: Show Nothing Until Data Entered

Oct 21, 2006

I am trying to create a simple IF/THEN statement to display profit margin for an order form. I currently have the margin formula set at (1-H14/I14). How should I structure my IF/THEN, to where it displays nothing in the cells, that are empty?

View 5 Replies View Related

Left & Right Formula To Show Number Not/as Well

May 22, 2007

I have numbers in a cell such as 1/25, 4/31, 12/35 etc I have the current formula to extract the left or right number but when there is only a single digit it also includes the / is there a way of eliminating this.

The numbers vary from 1 to 2 digits.

My current formula is =IF(C15<18,LEFT(E8,2))+IF(C15>18,RIGHT(E8,2))

I only want it to show the number not the forward slash

View 9 Replies View Related

Formula To Show File Name In Cell

Jun 23, 2008

I am trying to get my cell to match the name of the file. I am aware of the following formula: =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-5)

This does return what I want, but members of my team often have several sheets open within one Excel window. The formula returns the most recently opened file within the window rather than the name of that particular file. This then distorts my results sheet as it ends up with the name of the most recent file opened rather than the person's name (which is what the file is called)

View 3 Replies View Related







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