san

I've found plenty of sites talking about dependent data validation drop down lists, but none that I've been able to apply to my situation. I need three data validation lists, each dependent on the one before it - all three lists will come from the same table. It would also be nice if the user...

Hi, I am trying to create averages with three criteria. See example below. I tried to create using the AverageIf function however when I added three criteria it wouldn't work. Please Note the formula did work with three criteria. I was told I need to use macros to make it work. Please respond...

Hey guys, I need a help. I need hep with a IF statement. conditions are: If cell D43 is greater than or equal to 1, then i want it to show text "san" if cell D43 is in negative number and is greater than or equal to -1, then i want it to show text "san" If cell D43="", then "" I did this...

Hello Guys, am new in dax and would like someone to help me how to sum up a particular result in a DAX code. The DAX code i wrote is as follows: Column = CALCULATE( VALUES(Customer[City]), //COUNTROWS(Customer), //VAR SD = 1...

<tbody> Sheet 1 Sheet 2 Sheet 3 Sheet 4 Sheet 5 Sheet 6, Column 1 Sheet 6, Column 2 Summary Los Angeles San Francisco Bakersfield San Diego All California Census Tracts Do they have good tacos? Los Angeles 5432 Y San Francisco 9876 N Bakersfield 1234 N San Diego 5678 Y...

I've seen various q+a around this topic but can't get any of the suggested answers to work. I need help crafting a formula to find the number of unique companies that are both Special per column B and have an Investment Date in column C. I'm able to calculate the total of 5 Special companies...

I have a file where I have a data dump from our database and I would to extract data from it for different offices. It could be run several times a day or several times a week since the data is always changing. The user will do the following steps the file: 1) Copy the data dump onto a new...

<colgroup><col></colgroup><tbody> HoltsvilleIRS San JuanWest San JuanEast Virgin Islands *San JuanMain SpringfieldVicinity *SpringfieldMain Pittsfield Greenfield Fitchburg WorcesterVicinity *WorcesterMain Framingham Woburn Lynn BrocktonWest BostonMain 1...

I've tried to figure out how to find specific text in a string of text and darned if I can. In the example below I am trying to find the city name San Jose in a long string of text and then have San Jose stated in another column. However, when I use this code below, I get San Jose populated in...

I have the following data. TAB 1: <tbody> <tbody> A B C 1 Location Month Rate 2 San Diego Feb-18 </tbody> </tbody><colgroup><col><col span="2"></colgroup> TAB 2: <tbody> A B C D 1 Location Season Start Season End Rate 2 San Diego 10/1/2017 12/31/2017 $153.00 3 San Diego...

Hello to all, How can I divide this string of texts: minimo maggiore, via gallo 788 - san giovanni giovanni, 88018 / brindisi or minimo maggiore, via gallo 788, san giovanni giovanni, 88018, brindisi in 5 colums without using function text in columns? max_max