Search results

Did you get access to review?

Did you get access to review?

Here you go... Tracking Report: https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!113&parid=8C4598BED3EF132A!108&authkey=!AJ7yC0bayODTBZk Thank You

Rats! All I get is zero's when I enter in the formula... I did fiddle around with it and got the true and false but, I didn't know I was on the right track so I deleted what I entered... I need to obtain the dollar amount... What I am I doing wrong?

Here's the link for the source report..... https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!111&parid=8C4598BED3EF132A!108&authkey=!AFU_dk6bjOz_4hs Here is the link for the CSR report which is where I need the rows to expand of course based upon the source...

What column or report would I put this formula? in the report generated by dept. or the master report and where exactly? last line of each section 1, Travel 2, Office Supplies 3, Misc.? Please advise...

My raw data are reports which are linked to the master reports with the sections I have noted above...I do not have a rawdata list or spreadsheet. Its literally being pulled from a report that generated by each department.

Hmmmm I get all zero's... Is this formula referencing column 4 which is where you would get the dollar value?

I must be in limbo?

Is everyone still on holiday?

Column(1)ITEM NAME: TST, RSS, DVS, MSD, Etc...COMM is what I need to find Column(2)ACCOUNTING NUMBER: all kinds of account numbers, I need to find only, 1011000010,1011000012,1011000100,1011000500 Column (3) ORDER DATE Column (4) DOLLAR VALUE... $11.00, etc... Column (5) DEPT NO...

I came up with this formula... But it allows all the dollar values from Column D. I can only have the dollar values based upon my criteria... COMM in column A and Account Numbers: 10110000012,etc. in column B.... HELP...

I came up with this, but it doesn't work... am I close or in the right ball park? =IF($A$2:$A$5093="COMM",OR($B$2:$B$5093=1011000010,$B$2:$B$5093=1011000012, $B$2:$B$5093=1011000020, $B$2:$B$5093=1011000200, $B$2:$B$5093=1011000500)*SUMPRODUCT(('Main Report - Master'!$K$9="Actual"))) This...

Unfortunetly, the source report can not be altered, filtered, manipulated... It is only for a source of data and this data is linked over to the other report that will have the formula's and do the matching and provide the dollar amounts. Any ideas how this can be accomplished? Perplexed!!!

Thank you for the options, but I can't seem to get any of the options to work... Keep in mind this is all linked data that we are searching through... Does that have an impact? I do get zero's but no dollar amounts...on the rows I know there's a COMM or the proper Account #... Any other...

I have five Columns and 5,000 rows of data from a source report... Need Search Columns(1)need to find all COMM and search column (2)Accounting Number (1011000010 and 1011000012 and 1011000100 and 1011000500) So there's letter's and numbers that will be searched through... Each row has a...

ekkkkk!

I have a consolidated report that has links to many source reports, which provide the data. When the source reports have additional information added, which must be manually added with there new rows shouldn't the new data and rows automatically populate on the consolidated report it rolls...

Thank You!

I tried it and it works beatifully! Thank You! This is what I put: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E31," ",""),",",""),"1",""),"2",""),"3",""),"4","")="" Now does the data validation allow for row expansion... Let's say I set up so many rows within the...

I did a search and seen some application that can be purchased that can fix the links... Have you heard of these app's and any good things about these applications? I am so new to this realm if I would have been messsing around with this stuff years ago I may have a clue. But unfortunalty I am...

AWESOME!!! It worked beautifully. Genius!!! One questions if I know the individuals entering into this cell they may or maynot attempt to use a space to separate the numbers? example: 1, 2, 3, 4. not 1,2,3,4... Can the space also be incorporated as well into the formula...

I tried unchecking that box and it did nothing... Question we all are under the impression that the numbers are being entered with the proper comma... correct? They must be separated with a comma... Would that have an effect?? Just tested my thought and it's the comma... If I input 1234 its...

This is what I have under data validation criteria: allow custom... Checked off Ignore blanks, data: between, formula entered: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E30,"1",""),"2",""),"3",""),"4","")="" Yes the style is set-up to STOP! It was just working the first time I entered...

Yes Sir! that is exactly what I did...To redirect where the consolidated document could find the source document it has links connected too it... At first all of the links showed as unknown that I selected change source went to source document at it's new location and then updated values. This...